Multiple Lookup Fields

[Melissa]

I would love some help with a form question. I have a basic invoicing
database with a form for inputting orders (a subform in a Purchase Orders
mainform). The user would like to be able to enter products ordered using
either the ItemNumber or the SKUNumber - both of which are unique to each
product. I have the ItemNumber set as the primary key for the products
table. Is there a way to allow the user to enter information using either
the SKU Number or the ItemNumber? Note: My Orders table is setup like so:

Name: Orders
PurchaseOrderNumber (foriegn key - linking to the PurchaseOrders table)
ItemNumber (foriegn key - linkign to the Products table)
Quantity

Any help would be great. I've tried building code for this, but I am a real
amatuer.

 

[Jeff Boyce]

Melissa

One approach might be to add an option group with "Item#" and "SKU" as
choices.

In the AfterUpdate event of that option group, you could (re-)set the SQL
statement that feeds the combobox, thereby allowing the user to select the
item from the proper list.

Regards

Jeff Boyce
Microsoft Office/Access MVP