Add Field from another table?

[Cosmos75]

I've created a form based on one table.

I now have to add a related field from another table. How do I do this? I open the field list but have no idea how to open up another table, only the table I started my form with is showing.

Thanks!

p.s., I've decided NOT to post a poll with this post. Let me know if people like seeing polls?

 

[David R]

Right-click in the Query Design Window, Show Table

And no, the polls don't seem to be too popular.

 

[Howlsta]

Why don't you just base the table on a query? Create a query with the tables you want and add all the fields from the original table(that you had in your form before) and just the one field you need from the other table.

Rich

 

[cstanley]

You can do this by making a subform in your form, based on whatever second table you want to use. You can have a subform that displays only one field.