Duplicating Fields

Resolved · Low Priority · Version Standard

Duplicating Fields

Elaine has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Elaine [8 posts] (2008 Feb 8 Fri, 14:52) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Duplicating Fields

by - trainer David gold contributer [428 posts] (2008 Feb 8 Fri, 15:27) Reply

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

by - delegate Elaine [8 posts] (2008 Feb 8 Fri, 15:31) Reply

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

by - trainer David gold contributer [428 posts] (2008 Feb 8 Fri, 16:13) Reply

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

· When Is Microsoft Access Not The Best Choice For Your Business?
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· How Reorganising Your Data Can Take Your Business to the Next Level
· How To Find Good Access Database Courses In London
· Access VBA Handling Errors and Debugging Code

Please browse our web site to find out more about
microsoft access training and other Microsoft training courses.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips

Rate this page: