M
MarcM
I have three tables:
Table 1 (Parent table) that has all the clients names,
demo stuff and a unique file number that is the primary
key.
Table 2 This table is called Intakes. In this table, I
have created a primary key called ADM_ID (auto number) and
is the primary key. This table contains separate
admission information on each client. Clients may have
many admissions over time. I have it linking to the Table
1 to look up client (via combo box based off of
table)...works great
Table 3 is where I have problems. It is called Encounter
Log. I have to track each time services have been given
to each client during that admission (could be hundreds)
How do I get it so that it will link to the correct
admission in table #2 and that it shows the client's
name? I would like it to show the client's name as
opposed to the ADM_ID because it would be more
understandable to other users. In this table, I have an
auto number called ENID as primary key for this table.
I am thinking that I have serious issues with my
relationships, or primary keys or something. I have tried
it over and over and each time I enter something in Table3
it says that I do not have a related record. I am so
frustrated with it. If you know how to fix this, can you
please help me out. I am a newbie so if you can bring it
down to the "Access for Dummies" level that would include
me
.
Table 1 (Parent table) that has all the clients names,
demo stuff and a unique file number that is the primary
key.
Table 2 This table is called Intakes. In this table, I
have created a primary key called ADM_ID (auto number) and
is the primary key. This table contains separate
admission information on each client. Clients may have
many admissions over time. I have it linking to the Table
1 to look up client (via combo box based off of
table)...works great
Table 3 is where I have problems. It is called Encounter
Log. I have to track each time services have been given
to each client during that admission (could be hundreds)
How do I get it so that it will link to the correct
admission in table #2 and that it shows the client's
name? I would like it to show the client's name as
opposed to the ADM_ID because it would be more
understandable to other users. In this table, I have an
auto number called ENID as primary key for this table.
I am thinking that I have serious issues with my
relationships, or primary keys or something. I have tried
it over and over and each time I enter something in Table3
it says that I do not have a related record. I am so
frustrated with it. If you know how to fix this, can you
please help me out. I am a newbie so if you can bring it
down to the "Access for Dummies" level that would include
me
.