Hi All,
I am trying to setup an interface for a user to import a list of items into the database. What I'd like to do is allow them to pick the file to import and then import that file, creating the records in the related tables as well. The trouble is I don't have the ID from the main table until the record is added.
I am just starting to plan this and so far I have thought of storing the data in a temporary table, then looping through the records, opening and closing the form I have now to add each record individually. Then I would have the ID and could run the insert statements as I do now.
Another method I thought of is to run another query to id all of the records in the main table that don't have records in the related tables and run insert queries based on those ID's.
Any suggestions on the approach here would be appreciated.
Thanks!
I am trying to setup an interface for a user to import a list of items into the database. What I'd like to do is allow them to pick the file to import and then import that file, creating the records in the related tables as well. The trouble is I don't have the ID from the main table until the record is added.
I am just starting to plan this and so far I have thought of storing the data in a temporary table, then looping through the records, opening and closing the form I have now to add each record individually. Then I would have the ID and could run the insert statements as I do now.
Another method I thought of is to run another query to id all of the records in the main table that don't have records in the related tables and run insert queries based on those ID's.
Any suggestions on the approach here would be appreciated.
Thanks!