Forms displaying data from different tables (easy)

[Jon L]

I've got a form that enters data to one table. It's
related to a different table from which I want to retrieve
information but not be able to change it (i.e. just a
reference on the form). Here's the setup:

Table projects has 'projectID' and 'projectName'.
The form in question enters data to table isolation and
each row has one, not unique, projectID. I want to just
display the projectName from the projects table, I don't
need or want to change the projectName information.

When I changed the select statement for the record source
of the entire form to include the field from table
projects, it will work but only return unique projectName
(s) - since it's reference I need to be able to see them
all. I also thought that making a single field on the
form with a SQL select statement would work, but to no
avail. So, what's the easiest solution?

Thanks in advance...

-Jon

 

[Joan Wild]

Just make a form based on the isolation table.

You can use the combo box wizard to create a combobox that looks up the
project name, while storing the projectID.