What is the best way to import data into multiple linked tables

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
The only thing I would do differently would be to link to the spreadsheet
rather than import it.
 
Back
Top