Forum home » Delegate support and help forum » Microsoft Access Training and help » Duplicating Fields
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Duplicating Fields
Resolved · Low Priority · Version Standard
Reply Fri 8 Feb 2008, 14:52Delegate Elaine said...
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?
For upcoming training course dates see: Pricing & availability
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
Reply Fri 8 Feb 2008, 15:31Delegate Elaine said...
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
|