When you create a Table you'll usually have an AutoNumber Field as your ID. When you want to create a Relationship to another Table you can add a Foreign Key in this second Table, name it the same as your PrimaryKey in the first but make it a Number Field this time. Now just put the ID from the first in the Second and then you can join them in a Query
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 4.
