By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,496 Members | 1,489 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,496 IT Pros & Developers. It's quick & easy.

How to Populate Some Fields from Other Table Primary Key

P: n/a
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
Apr 10 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Apr 10, 5:44 pm, "Steven" <sche...@verizon.netwrote:
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

Apr 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.