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

Link two tables?

P: n/a
I am new to Access and need to link to two tables with a case number.
If I link using the Relationship feature will it automatically enter
the case number in the child database if I put the case number in the
main database like it does in Approach or do I have to do something
different. When I tried to set up to autonumbers the link did not work
correctly.

Appreciate any help as I am new to Access.

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


P: n/a
You need to set primary keys in both tables (strictly speaking the
second will be a foreign key but you don't have to specify that, access
works it out for you) and also make sure the linked fields are of the
same data type, probably both number unless your case numbers are
alphanumeric. If alphanumerics try creating two fields, one an
autonumber and the next a text field that you enter the case number in.
Link the autonumber field to the second table autonumber field and run a
query calling in both tables. The query will then show whatever you
want, probably you will hide the autonumber and just show the case
number. Hope this makes sense, good luck

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #2

P: n/a
Randy wrote:
I am new to Access and need to link to two tables with a case number.
If I link using the Relationship feature will it automatically enter
the case number in the child database if I put the case number in the
main database like it does in Approach or do I have to do something
different. When I tried to set up to autonumbers the link did not work
correctly.

Appreciate any help as I am new to Access.


Nothing will happen automatically in the tables, however if you use a
main and subform to enter your data and specify that column as the link
master/link child then the relevant foreign key will be entered into the
subform automatically.
--
This sig left intentionally blank
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.