Table column a query of another table

[jmob]

I have table A with multiple fields(columns) I would like to set one of the fields to a query from another table that returns 1 result. Can this be done, and how? Thanks.

 

[jmob]

I forgot to add, either doing this within the table, or in the form would both work for me.

 

[PHV]

Have a look at JOIN

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886