Relationships or something

A

Anna

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...?
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top