G
Guest
Hi I have a simple database which has a master table for suppliers, with a
sub-datasheet of Supplier Offers, which has a sub-datasheet for Supplier
Items.
To simplify data entry of similar data, I have had a request to setup a
spreadsheet import which will allow users to enter the Supplier Name (main
table), the Offer Name (sub), and all the Item details (sub-sub) in one
sheet, so columns can be copied down. then this can be imported.
The only way I can see to do this is to import the sheet into a table, then
update the three tables with a query. Does anyone have any other ideas?
Many thanks
*M
sub-datasheet of Supplier Offers, which has a sub-datasheet for Supplier
Items.
To simplify data entry of similar data, I have had a request to setup a
spreadsheet import which will allow users to enter the Supplier Name (main
table), the Offer Name (sub), and all the Item details (sub-sub) in one
sheet, so columns can be copied down. then this can be imported.
The only way I can see to do this is to import the sheet into a table, then
update the three tables with a query. Does anyone have any other ideas?
Many thanks
*M