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

Can I join an ID in a table with a First and Last Name in another table?

P: 1
I want to join a patient id from a table to a first name and last name in another table, how can i do that?
May 18 '15 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 5K+
P: 5,397
Sounds like an unusual table setup.
Normally you would link in the primary-key field(s) to the foreign key field(s) between the two tables. Then using a query one would pull the related information for use in reports etc.

Table relationships are established in several ways and with several options; however, the most common is via the database tools ribbon/menu and then by the table relationships option in a one to many relationship. (MS-Tutorial here) Mind you, I very rarely ever use cascade delete... too easy for the user to delete all of one's data by accident... made that mistake once and thankfully I had just backed up the data tables!

The articles located at:Microsoft Access / VBA Insights Sitemap may prove to be helpful for many of your questions and in particular the article on Normalization and Table Structures might help you with the design.
May 18 '15 #2

Expert Mod 15k+
P: 31,769
The simple answer is "No. You can't."

JOINing must be done with similar values as that's what it means. "John" will match "John", but never 34127. In most cases, even the fields that store the data are constrained to be set up the same.
May 18 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.