Table Autolookup

[sarki]

Hi

According to Microsoft Office Assistance "About AutoLookup queries that
automatically fill in data (MDB)", it appears possible to create an
autolookup from one table in another.

However, the information actually how to do this is very vague and I can't
seem to find anything on it from Microsoft Online either.

I have been able to get the AutoLookup to work in a form, but will find this
somewhat limiting because of how the database has been designed.

I have a table called "Names" with a primary key "NameID" which contains the
Surname, Firstname etc of all people. I have set up a second table
"Relatives" which contains "NameID" as a foreign key and FatherSurName and
FatherFirstName fields. In order to minimise misspelling of names, the
FatherSurname looks up the Surname field of the "Names" table. I would like
to be able to have the FatherFirstName field complete automatically when the
FatherSurname field is selected. Hope that makes sense.

Do I set up the Relatives table based on a query of some sort, or is there
some other magic solution. I am currently not very familiar with VBA just
yet so I'd prefer a query or SQL solution if possible.

I would really appreciate your assistance.

 

[Sailormike]

R u familiar with combo boxes? Sounds like u need one based on a simple query.

If u r NOT familiar with them maybe u should consider a book or class on
Access. If u plan to do much of anything with this DB u r going to need the
skills involved with comboxes, and other objects as well.