LookUp box

[Hank]

I have a table with 3 look up boxes. One is the contactID (autonumber from
another table), One is the Last Name, and one is the First Name.
When I look up and choose the last name or first name in the drop down box,
Access displays the contactID in this text field.

What I would like to do is look up the last name and have it automatically
display the contactID and First Name in the other boxes.
Thanks

 

[Duane Hookom]

Combo boxes are for forms. Lookup fields in table designs is frowned on by
many of us http://www.mvps.org/access/lookupfields.htm.

Your table structure isn't clear. Individual's names should be stored in
only one table. The ContactID value can be stored in other tables.

Can you provide more information about your table structures and what you
would like to have displayed on your form?

 

[Hank]

Thanks for the information. After reading the link, I understand why
lookups are not the best method.

I have a working database in Access 2003 for a day car center. It has 2
tables. One has the basic info for each child, (name, address, parent,
medication, phone, etc). The other is a list of persons authorized to pick
up the child. The tables are link with the contactID on the main table.

What I want to do is add a table for payments. I have in mind using a form
with a drop down list of all the kids, then posting the payments received.
The table would include a date due and date paid, how paid, and total paid
column. I want to be sure the payments are posted to the correct child.

I am new and learning and appreciate the help.

Thanks

 

[Duane Hookom]

Your payment table should store only the primary key value from "One has the
basic info for each child".

Where does your "date due" come from? I don't think this would necessarily
be included in your payments received table. You might want to spend some
time on your table structures.