All,
I am using access 2003 and I need help on importing data. I have already setup a table I to import data and I am using it in a subform on my main form. The first table is the invoice table which I have as the main form for data entry. The users create a record inputting the invoice number and corresponding info. The users then switch to a subform to input data corresponding to the invoice table. I have a combobox on the subform so the users can select the invoice number. It should auto populate the corresponding fields from the main form. Next it should auto populate the remaining fields in relation to the remaining fields. But, the information in the subform is imported from an excel file that I have to setup so the users can push an import button and populate this existing table. The main table contains the invoice # and the imported table has invoice # and the tracking number. I have setup a 1: many relationship between these two tables. The invoice # can have many tracking number records. The imported file contains records with the invoice # and tracking number then corresponding data. I at a lost in setting this up. I think my problem is that the users create the record with invoice# before data is imported to the corresponding table. After the users select the import # from the subform they still would have to select the corresponding tracking #. Can someone please help me with this design and thought process.
Thanks