Linked Combo Boxes 1

[jsanderson]

I have a two table database (tblUnits, tlbPayments) with two
forms (frmUnits, frmPayments). The fields of tblUnits are UnitID(primary key), PropertyNumber, UnitNumber, FirstName... The fields of tlbPayments are PaymentID (primary key), UnitID, PaymentAmount....
There is a one-to-many relationship between the UnitID fields of tblUnits and tlbPayments respectively. UnitID is autonumber and is only there because UnitNumber is not unique (each PropertyNumber could have a unit number "1&quot. The problem comes in when I try to create linked combo boxes on my payments form in which I would select Property Number first and cboUnitID would be populated with only the unit id's for that property. I would like UnitID to be a transparent value to the end user so that they would see Property #1 and Unit#2 and the fact that that is really UnitID 123843 is hidden. I tried binding column 1 (UnitID) and setting it's width to 0" and setting column count to 2 and column width for UnitNumber to 2". I can see the proper column header in the dropdown but no data is shown. Any suggestions or am I really far off base?

 

[KenReay]

hi

No you are not off base, you are spot on, you hav eactaully selected both columns in the SQL Query behind the combo haven't you?
Hope this helps

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use