Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Changing Existing Relationships
|
|
|
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. |
microsoft training access course - Changing Existing Relationships
Resolved · Low Priority · Version Standard
Reply Wed 5 Dec 2007, 16:58Delegate Oliver said...
Oliver has attended:
Access Intermediate course
Changing Existing Relationships
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?
For upcoming training course dates see: Pricing & availability
Reply Wed 5 Dec 2007, 17:07Delegate Oliver said...
RE: Changing Existing Relationships
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).
|
|