simply query

[Keiath]

I have a main Table that holds all core data that gets data from other tables.

I need a query that returns the following data:-

Site Manager = Site number, Site Name

Each manager, manages a number of sites

in the site manager table i have the following fields ID (PK) and Site manager

This is displayed on the main table via a combo box.

When i run a query I get the ID number not the name. and it list by site number not the site manager

Please help

 

[jzwp22]

You will need to include both the main table and the site manager table in the query. Then include the name field(s) in the query.

Having combo boxes at the table level can cause some issues (just like you describe and others. Please take a look at this site that describes the other problems table-level lookups (combo & list boxes) can cause.