Hi,
I have three tables: (1) Sales and (2) Sale Details (3) Slabs
(1) Sales Fields
- ID (primary key)
- Invoice Number
- Customer ID
- Date
(2) Sale Details Fields
- ID (primary key)
- Sale ID (foreign key to Sales)
- Slab ID (foreign key to Slabs)
- Rt/SqFt (price)
(3)Slabs Fields...
Hi Gary. Could you please explain your solution to this thread a little more:
http://www.access-programmers.co.uk/forums/showthread.php?p=533067#post533067
I am in a similar situation. I need to add about 5000 records to my database, but the related fields are spread out over 2 tables, so I need...