Field changes stopped queries...

[AlanGNW]

Relatively new to Access - but not completely incopetent

I've been building a relatively simple Access (2000) database. And made the mistake of putting free text into a couple of fields at set up and then changing them later to combo boxes drawing on other tables (i.e. a client list and a list of sales contacts. In doing this I now find that mt queries using these fields dont work.. also when using find this also does not work - however it does appear to work when using numbers? How can I fix it to see the fields in text again rather than the record ID's on the secondary tables?

Thanks in advance for your help!

 

[PHV]

JOIN the secondary tables in your queries.

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

 

[AlanGNW]

At the risk of sounding like a total numpty... how?

Thanks
A

 

[Remou]

Something like this, perhaps (Query Design, SQL View):
SELECT [Field]
FROM [MainTable] INNER JOIN [LookupTable] ON [MainTable.ID] = [LookupTable.ID];

There are various different JOINs, the above illustrates just one.