Drop down List Box like a tree.

[trident]

I have a form that is for entering data, my problem is that the dropdown list box is showing only the ID No (autonumber), hope you can see thru this breakdown

Table Model	Table Description	Table Brand
tMID	tDID (Dropdown for Table Model)	tBID
tmQNo	tDBrand (dropdown from Table Brand) save is the tBID	tBName
tmModelNo (Drowdown List box from Description) what is saved as connection is the tDID	tDModel	tBType

Now in the form, what I want to appear in the tmModelNo is the tBName, however, only the number is appearing. How can I have the tBName appear.

Hope you can enlighten me again on this.

Trident

[Bob Fitz]

I'm not sure about what you're trying to do but I wouldn't use "Lookups" in tables (if you are). I would only use those in forms.