Getting data for a combo box from 2 different tables

[ryetee]

I have form with a combo box that displays error messages from Table A.
These error messages are linked to Table B via an ID.
The other table also contains an error message.

I can obviously display the error message and ID from Table A in the drop down box.

What I want to be able to do is display the error message from TableA and also the error message from Table B.

Is this possible and if so how?

The control is bound to a further table but the ROW source is via a select statement. Is it as simple as changing the select to some query? If so how do I select the fields to display or are all the fields in the query displayed?

 

[pbaldy]

Yes, you should be able to build a query with both tables in the grid, joined by the appropriate field, with the desired fields from each table selected.

 

[RainLover]

Use the query builder.

Select the Tables you want making sure the join is correct.

Then bring down only the fields in order that you want.

You may need to include the Primary key and set its width to zero so that it cannot be seen.

 

[ryetee]

Thanks Pbaldy and rainlover got there in the end!

 

[pbaldy]

Happy to help!

 

[RainLover]

It helps others if you explain the solution

 

[ryetee]

It helps others if you explain the solution

Sorry missed this - I used your and PBaldy's advice