Combo boxes on a form

[Maranna]

Hi

I've searched the net looking for an answer to my problem but to no avail.

I have a form called formEstimators (Accessed via the View Tenders Button) and I want to have a search on the form however my company combo box only displays the companyID instead of the name, which is no use.. also the second combo box (Estimators) I want that list just to be the Estimator's names who are associated with the selected company, if you get what I mean?

Any help or if anyone can fix this for me would be greatly appreciated.. as I'm pulling my hair out!

Many Thanks
Maranna

[RuralGuy]

Now you know why developers strongly recommend *not* using Lookup Fields in tables.