Hi Guys,
I am working on a Billing Database. I have tblPurchase (Parent Table) & tblPurchaseDetail (Child Table). the tables are linked through tblPurchaseID (Autonumber field - in tblPurchase).
Now I Have data for both the tables in excel format, except the Purchase ID, as it is assigned by Access upon inserting records. I have no issues importing data for tblPurchase, but when I will try to import data for tblPurchaseDetail (tbl PurchaseID field is not present), how can i link records to corresponding records in tblPurchase.
In excel file (Data for tblPurchaseDetail) I have bill Numbers mentioned in front of every row to identify to which bill the details actually are linked.
Awaiting your help and guidance.
Regards
Deepak Gupta