I've seen a lot of discussion on ComboBox showing ID rather than text and ways to fix that, but my problem is the opposite. My ComboBox is showing the correct information but when the DropDown list is shown the first column has the Person's name just fine, but the other columns in the dropdown list just show ID's to their related fields.
I have Fields in my Combo DropDown on a form as NameEmp, TruckEmp, and TrailerEmp. The information is coming from table called Employees. On the Employees Table TruckEmp and TrailerEmp are ComboBoxes pulling values from another table EQ. Both the Real Truck and the Trailer numbers are in the same column on EQ in a field called UnitEQ and the table has IDEQ as primary key.
If I delete the relationships Employee-EQ and just put in my Truck and Trailer numbers on the table, the dropdown list on the form will display correctly but then it will not auto populate other Truck and Trailer fields on my form (which are also comboboxes) on after update. With the relationships intact, the auto populate works fine but then my dropdown list shows the ID of the Truck and Trailer rather than the Unit#. The Form is actually supplying another table for job details and I am trying to auto populate the truck and trailer that an employee normally will use but still allow the flexibility for an employee to use a different truck or trailer as needed.
Thanks in advance for any fixes or suggestions!
...Chris
I have Fields in my Combo DropDown on a form as NameEmp, TruckEmp, and TrailerEmp. The information is coming from table called Employees. On the Employees Table TruckEmp and TrailerEmp are ComboBoxes pulling values from another table EQ. Both the Real Truck and the Trailer numbers are in the same column on EQ in a field called UnitEQ and the table has IDEQ as primary key.
If I delete the relationships Employee-EQ and just put in my Truck and Trailer numbers on the table, the dropdown list on the form will display correctly but then it will not auto populate other Truck and Trailer fields on my form (which are also comboboxes) on after update. With the relationships intact, the auto populate works fine but then my dropdown list shows the ID of the Truck and Trailer rather than the Unit#. The Form is actually supplying another table for job details and I am trying to auto populate the truck and trailer that an employee normally will use but still allow the flexibility for an employee to use a different truck or trailer as needed.
Thanks in advance for any fixes or suggestions!
...Chris