Fields in form display IDnumbers instead of Names

[nshenry03]

The fields in my form display IDnumbers instead of Names/descriptions.

I have three tables

OIIParts Machines MachinesUseParts
-------- -------- ----------------
PartID MachineID and OIIPartID
Description Name MachineID
... Description
...
a main form for entering in parts
and a subform that is used to choose which machines use the part. Everything works well, when a user goes to choose a part, he is able to see the name/description of the machine, but once he/she chooses, it only displays the ID number (which is how I have it stored in the table) is there any way to have this subform display the name/description rather than just the number?

 

[Remou]

Is this set up with comboboxes? If so, you can set the column widths on the Format tab of the property sheets. For example, setting the column widths to 0,2 will hide the first (key) column and show the second (description) column, while still returning the key.

 

[nshenry03]

yea, it's set up w/ combo boxes, and setting the column widths to 0";2" is what allowed me to see the second column (the Name column) when selecting, but it doesn't seem to work to show the numbers once something has been selected

 

[Remou]

Ah, I missed that point. Base your subform of a query that includes the parts table or else change the subform parts number control to a combobox, too.

 

[nshenry03]

I'm sorry, I'm not sure I understand what you mean by the second part (I think I'd like to try that first)

 

[Remou]

Ok, does you form look something like:

[tt]CboPart : [ Description ]

-------------------------
McID McName [blue]Part[/blue]
-------------------------
1 Abb 9
2 Bcc 10
5 Eff 11
-------------------------[/tt]

You can change the [blue]Part[/blue] control to a combobox. If your form does not look something like the above, I have missed your point.