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

[hh22]

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?

[zmbd]

HH22:
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.

[NeoPa]

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.