Combo Box Value From Two Tables

[Guest]

I have two tables (Students, Fluoride) which both have an ID key and they are
related through that field.

The form I am trying to create has fields from both of those tables:
used the wizard to select ID, FirstName, LastName, and Homeroom from the
Students table and the Fluoride field from the Fluoride table.

I can display the data for each student correctly through the form.

I am now trying to add a combo box that will allow me to call up a specific
student by ID#. In other forms I have been able to do this, but not on this
one. I suspect because I am drawing data from multiple tables that is why I
am unable to do this the same way.

Looking through the one book I have and searching has been futile. I
suspect I do not have the correct terms to search for.

Can someone direct me to what I should be doing to be able to "look up" a
student in such a form?

Thank you.

 

[Guest]

Have you tried combining the tables into a query, using that query as the
basis for a form, and setting up your combo box to find a particular record
as you have in the past or through the combo box wizard? If that doesn't do
what you need it would probably help if you spell out the relationship
between the tables. Is [StudentID] the primary key from the Students table,
and is it also a foreign key in the Fluoride table? If so, are the tables
related one-to-many through that field?

 

[Guest]

Have you tried combining the tables into a query, using that query as the
basis for a form, and setting up your combo box to find a particular record
as you have in the past or through the combo box wizard?

That did it! Thank you kindly.

 

[Mike Frith]

That did it! Thank you kindly.

I have a somewhat similar task, well, maybe not. I have Table2 with
Name, I have Table1 with First_Name and Last_Name. Name can only be
populated from record values with First_Name and Last_Name. For example,
Casey and Stengel are separate columns in Table1 but in Table2 it is
Casey Stengel. I received a file with First_Name and Last_Name and
import it into Access. When populating fields in Table2 I'd like to have
a combobox appear with First_Name & Last_Name

The form might be like:

Manager:

First Base:

Second Base:

ShortStop:

Third Base:

Catcher:

I'd like the comboboxes to have appropriate field values, that is,
combine First_Name and Last_Name from Table1 to get Name for Table2.

Any suggestions greatly appreciated.

thanks
Mike