Relationships or something

So, here is the issue:
This DB should work in laboratory(for blood testings)... So, I have two
tables:
In my 1. table (cold patients)I have PatientID, JMBG(this is the number sth
like ID for all people. This number is required for all people to have it an
it contains 13 digits), assurance(which assurance patient owns), and all data
which laboratory counts(HDL,...)
In 2.table is DB which contains JMBG of all people (in town or sth...) and
their names and also adresses.
I want to conect this two tables so If I wold write someones JMBG(in table
patients or in form) I will get name.
What can I do? What to do with primary key...?

Take a look at queries for joining the two tables on their shared field
(?JMBG).

By the way, if your first table has one column for each "laboratory count",
your table is probably a spreadsheet, not a relational database table.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Anna" wrote in message
...
So, here is the issue:
This DB should work in laboratory(for blood testings)... So, I have two
tables:
In my 1. table (cold patients)I have PatientID, JMBG(this is the number
sth
like ID for all people. This number is required for all people to have it
an
it contains 13 digits), assurance(which assurance patient owns), and all
data
which laboratory counts(HDL,...)
In 2.table is DB which contains JMBG of all people (in town or sth...) and
their names and also adresses.
I want to conect this two tables so If I wold write someones JMBG(in table
patients or in form) I will get name.
What can I do? What to do with primary key...?