98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Creating lookups
Creating lookups
Resolved · Low Priority · Version 2007
Sarah has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Creating lookups
I am creating a database for recording customer orders for certain products. I have created a customer details table and a product details table. I am trying to create an orders table with a field in it called 'product' which contains a look up list which displays values from multiple fields in the product details table. However when I use the Lookup wizard to create this list and then use it, I can only see the first field value, not all.
For example: Customer wishes to order a chocolate sponge size 12 inch. Lookup list should display these by finding 'chocolate' from 'flavour' field, 'sponge' from 'type' and '12 inch' from 'size', however only 'chocolate' is visible.
How do I make the look up list to display the values together, ie 'chocolate, sponge, 12 inch' and how can I make it possible for the customer to select multiple choices in an order without making it a new record
Thanks (I am new to Access!)
RE: Creating lookups
Hi Sarah
Thanks for your question
In order to accomplish this you cannot use the wizard. You would have to use VBA and SQL to filter the form. This is covered on the Access VBA course, and is too involved to describe here.
As an alternative you could use the forms filter function to achieve your objectives. Siply click the filter button on the ribbon, and then enter the relevant values into the relevant fields
Hope this helps
Regards
Stephen
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |