creating lookups
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777
STL

Forum home » Delegate support and help forum » Microsoft Access Training and help » Creating lookups

Creating lookups

resolvedResolved · Low Priority · Version 2007

Wed 15 Jun 2011, 13:30 replyReply Delegate Sarah said...

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!)

For upcoming training course dates see: Pricing & availability

Fri 17 Jun 2011, 11:00 replyReply Trainer Stephen said...

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


 

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips

Training classes
London & UK

Live dates & prices »

On-site training

60-second quote »

E-Learning

From £99 · Call us »

Mailing list

Sign up for latest offers »

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.



Access training London
Course rating
4.8 stars - based on 4546 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom

info@microsofttraining.net

Resources