Do you happen to know how to get a lookup box in a form to return two values instead of just one value?
regards,
ekmoorhead
Do you happen to know how to get a lookup box in a form to return two values instead of just one value?
regards,
ekmoorhead
in Access 2010 there is a multi value field type - you can explore that as a solution.
otherwise a combobox is essentially the data from a query - you can manipulate that query design.
hope this helps.
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
I have 2 tables one for recording grocery receipts receipts tbl which includes date, item, qty, amount and total; the other table is category tbl which includes category and aisle. What I want is a form to use to input my grocery receipts where when I enter the item the associated category and aisle will automatically be included in the form.
regards,
ekmoorhead
Please show us your tables.
Each grocery item has a specific category and aisle?
I think the issue here is that "lookup boxes" is not conveying your intent - at least not to me.
I see a generic model, and only pieces of it seem to be applicable to your situation.
Customer-->Order--->OrderItem<-----Groceries<-----Category<--Aisle
Are you simply recording some info into a Table, or are you calculating the OrderTotals based on the Price and Quantity of groceryItems purchased by Customer??
Normally in data base you would not record Total, you would calculate as needed by means of a Query.
As othrs have aid, a better description, with examples, may improve communications and help resolve your "issue".
Thanks I will look into it.
regards,
ekmoorhead