Elaine has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Duplicating Fields
I have table A called "order". I have table B called "order items". I would like the "order ID" field on table A to be the exact same number as that which appears on table B as "order ID". This is so that the two items are distictly joined together. I want the field to be autonumber too. HELP! How do I duplicate/copy that fields content?
RE: Duplicating Fields
Hi Elaine,
I am not too sure if you can do this automatically as no link exists between the two tables. Therefore I think you will have to enter all the values in manually. Once all the values are in place you can link the two tables together.
Hope this helps
David
RE: Duplicating Fields
Table B is a subdata sheet to table A. Does that make it any more likely to do what I need it to?
RE: Duplicating Fields
Elaine,
I don't think so, as Access has no way of knowing which orders link to which order item, unless they are currently linked by another field.
Hope this helps
David
