Duplicating Fields

Resolved · Low Priority · Version Standard

Fri 8 Feb 2008, 14:52 Delegate 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:27 Trainer 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:31 Delegate 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:13 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips