Re: Order Form referencing two fields in table
Since this is data being saved, you can have two combos bound to a single field. The control will be bound to the ProductID which is the unique identifier of a product (unless SKU is your unique identifier). Then one combo uses a query that selects:
Select ProductID, ProductName, SKU From yourtable Order by ProductName
and the other is:
Select ProductID, SKU, ProductName From yourtable Order by SKU
Make sure the column count is 3 and the bound column is 1 and the column widths are:
0, 1, 1
so ProductID is hidden but both lists show both the name and the sku.
When you pick a value using one combo, the other shows the same result.
NO CODE is required.
When you have a form where you want to search by two values, THOSE combos would be unbound but I think we are talking here about a data entry form.
Bridge Players Still Know All the Tricks
Last edited by Pat Hartman; 08-15-2019 at 09:47 AM.