By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,997 Members | 1,470 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,997 IT Pros & Developers. It's quick & easy.

create relationship between two tables

P: n/a
Hey,

I want to create links between my two tables. The primary keys of these
two tables are character variables, with length =11. I followed exactly
the instruction of Dummuy Book for ACCESS 2003. I click the primary key
of table A , and hold and move the mouse to table B. But nothing
happened. No line, no error reminders. Does anyone know what's
happened? Thanks.

Mindy

Nov 26 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The process is this

1) Open the Relationships window (Tools/Relationships)
2) Select the tables you want from the dialog presented
3) Click on the primary key field in the parent table and keep the left
mouse button (LMB) held down
While keeping the LMB pressed down drag the mouse over the child
table (the mouse pointer changes to a horizontal rectangle while you are
dragging)
Let go of the mouse button
A dialog appears which shows the Primary key of the parent table on
the left and the field you "hit" when you let go of the mouse button on the
right
Change the fields as appropriate if required.
At this point you can add extra fields if you are using a
multi-field key
You can then set the Enforce Referential integrity options if you
need to

4) Click on the Create button and you should now see a line between the
two tables.

Alternatively:-
1) Open the Relationships window (Tools/Relationships)
2) Select the tables you want from the dialog presented
3) Choose the Relationships/Edit Relationship menu item
4) Click on the Create New ... button
5) Select the Parent table where it says "Left Table Name"
Select the Child table where it says "Right Table Name"
Select the Primary key field from the Parent table where it says
"Left Column Name"
Select the Foreign key field from the Child table where it says
"Right Column Name"
--
Terry Kreft

"Mindy" <ma************@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Hey,

I want to create links between my two tables. The primary keys of these
two tables are character variables, with length =11. I followed exactly
the instruction of Dummuy Book for ACCESS 2003. I click the primary key
of table A , and hold and move the mouse to table B. But nothing
happened. No line, no error reminders. Does anyone know what's
happened? Thanks.

Mindy

Nov 26 '05 #2

P: n/a
Terry,

Thank you very much for the detail instructions. I will try today. Have
a nice day. :)

Mindy

Nov 28 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.