Hello all

First time in this forum! Would love some assistance. I'm physician starting a small database of my patients.

I have 5 total tables. One is a demographic sheet, which everyone will have only once.

I then separate the patients based on the number of respiratory cultures they've had, only 1 or more than 1. Two tables will be for those with only one culture, the other two for those with two cultures or more.

All variables are in the first row like this (I can attach the table if needed):

One_many / Name / Medical_number / Culture_number / Date_obtained / Culture_#

The "One_many" variable will just be a 0 or a 1 (0 for one, 1 for many). The idea is that if this number is 0, the data gets linked to the two tables for those with only 1 culture. If it is 1, likewise, so those tables start filling automatically. If at one point the individual with only one culture now gets another one, I would change his "one_many" variable to "1" and he will be moved to the appropriate table.

All the other tables start with this exact variables. Note that one patient can have many cultures, but since each culture has its own identification number, I can eventually sort by individual and their specific information.

I know how to paste a special link to another table - but any help with this will be appreciated.