How to Populate Some Fields from Other Table Primary Key

[Steven]

Hi,

I would need some help here:

I have two tables, Patient (parent table) and Service (detail table).
Composite primary key for parent table is (fname, lname, pid), while
composite primary key for detail table is (service date, pid). pid is the
linked relation between 2 tables.

On openning form from detail table, I want a lookup from pid from parent
table, then populate fname and lname of parent table onto detail table, or
just show somewhere on the form screen.

What I have got is to get pid lookup value from parent table, but not sure
how to make it automatically to fill up fname and lname with the same value
associated with pid from parent table.

Any quick thought will be greatly appreciated.

Ste

[lgeastwood]

On Apr 10, 5:44 pm, "Steven" <[e-mail]:

Hi,

I would need some help here:

I have two tables, Patient (parent table) and Service (detail table).
Composite primary key for parent table is (fname, lname, pid), while
composite primary key for detail table is (service date, pid). pid is the
linked relation between 2 tables.

On openning form from detail table, I want a lookup from pid from parent
table, then populate fname and lname of parent table onto detail table, or
just show somewhere on the form screen.

What I have got is to get pid lookup value from parent table, but not sure
how to make it automatically to fill up fname and lname with the same value
associated with pid from parent table.

Any quick thought will be greatly appreciated.

Ste

Try this for starters
base your detail table on a query that has as criteria ie [Forms!
your_form!your_Textbox] where your_Textbox holds the criteria for the
query field