98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Duplicating Fields
Duplicating Fields
Resolved · Low Priority · Version Standard
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?
Fri 8 Feb 2008, 15:27Trainer David said...
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
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?
Fri 8 Feb 2008, 16:13Trainer David said...
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
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. |
Access tip:Convert A Form Into A ReportIf there is a form that you want to to save as a report: |
