Syncronizing Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a continuous form that has 2 linked combo boxes and I trying to
synchronizing them so that when you scroll through the records the 2 fields
in focus are exact.

Here is my table structure:

• MASTER
X (auto ID)
ss#
Surname
First

• Medical
Y (auto ID)
PERSON (X, surname)
Date

• Physical
Z (auto ID)
Person (X, surname)
Medical (Y, DATE)

To put into words what the structure is:
The Master table is the primary.
Medical & Physical references the Auto ID from the Master.
And I am referencing Date from the Medical table in the Physical table.

Now my form (frmPhysical) is based on the Physical Table.
I have successfully cascaded the 2 fields, Person & Medical to when you
select Person, it shows the dates they have had Medicals.

My next task is when you scroll through the records, you will see the
correct date for each person.
 
Back
Top