I have a main table and a subtable. The unique field is called container ID. This container ID is in both tables to support the link as the master and child field. However I now have a need to add an autonumber to be able to perform other functions. I added the autonumber to the main table with no problem, but I don't know how to add the autonumber to the subtable.
EXAMPLE:
Main Table ID Container ID
1 A6554-3
2 B6678-2
Subtable ID Container ID Contents
need this ID 1 A6554-3 Hammers
need this ID 1 A6554-3 Nails
need this ID 2 B6678-2 Saws
need this ID 2 B6678-2 Plyers
Thanks in advance - John
EXAMPLE:
Main Table ID Container ID
1 A6554-3
2 B6678-2
Subtable ID Container ID Contents
need this ID 1 A6554-3 Hammers
need this ID 1 A6554-3 Nails
need this ID 2 B6678-2 Saws
need this ID 2 B6678-2 Plyers
Thanks in advance - John