microsoft training access course - Changing Existing Relationships

Resolved · Low Priority · Version Standard

Changing Existing Relationships

Oliver has attended:
Access Intermediate course

by - delegate Oliver [3 posts] (2007 Dec 5 Wed, 16:58) Reply

The database im currently using was passed on to me by a collegue.

The main table contains an oilfield 'Name' but the fields have not been given ID numbers. I want to add this as an autonumber, which i believe is fairly straight forward. However, this main table has a lot of relationships coming flying out of it, linking to other tables by the 'Name'.

What must i do to make sure that the links are maintained correctly when i swap them over to ID instead of name?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
2003	2009 Jan 28 Wed	Bayswater	8	book now	£110	£205
Full Schedule: See all 44 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Changing Existing Relationships

by - delegate Oliver [3 posts] (2007 Dec 5 Wed, 17:07) Reply

PS. What im also concerned about is, whether i can Add this ID field to the main table and also have this update properly into the other tables, without having to type it in for each (the database has around 2500 records).