1. Start Access and open the database we created in the last tute, select the 'Tables' tab. Your database should now look like the one below, if not then you can download the database click here to download.


2. Lets edit the relationships of the tables in the database...


3. To add all the tables in one step, select all the tables by holding down the shift key and click with the left mouse button, then press the 'add' button.


4. Layout the tables so they look something like the image below.


5. Create a new link between the 'ID' field in the 'Participants' table and the 'ID' field in the 'Mailing List' table (click and drag from one to the other). The following dialog box should appear, select the 'Enforce Referential Integrity check box so that no one can be entered in the 'Mailing List' without being entered in the 'Participants' table first.

Select the 'Cascade Update Related Fields' so that if an ID is changed then all references to that unique id will also be changed in all the tables that refer to it. 


6. The view below indicates a one to many relationship between the ID field in the 'Participants' table to the 'ID' field in the 'Maining List'.


7. Add links to all the tables, same properties as above.


8. Close and save the changes to the database relationships.





Copyright © 1999 R&D Robotics Pty Ltd, All rights reserved.
Any copyright subsisting in the above code and or literary works including source files vests with R&D Robotics Pty Ltd. ACN 086 345 137