Combi Boxes

[Guest]

Please can you help me as in a form I trying to Link a Purchase number in a
comi box to automatically populate another to text or Combi box to the Item.
For example

Purchase Number: 3333333 would automatically add Item: Pencil to another
text or combi box

 

[Guest]

Please can you help me as in a form I trying to Link a Purchase number in a
comi box to automatically populate another to text or Combi box to the Item.
For example

Purchase Number: 3333333 would automatically add Item: Pencil to another
text or combi box

I dont really see why you would need it to populate the same data into
another box? unless you have a specific need. i am assuming that the purchase
number is the key and item is the 2nd field.

In the underlying query for the combo box you could simply select both the
purchase number and the item. Then for the settings of the combo box change
colum count to 2 then change the column widths to 0:2 this will mean that you
select the item from the list and it will remain shown.

Please let me know how you get on

Falty