Windows Forum

Ask something
Question Locked

create your own lookup in Access 2003

0 helpful
2 replies

by soulrebelpd

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to create a pop up form that creates a new record(the fields are Customer, PetName, Breed, PrimaryGroomer, DOB, etc). I have been told that using the Lookup feature of Access is not very good. I want the user to be able to choose the Breed field by using a combo box that lists all the Breeds in the system. What is the best way to accomplish this?

2 replies

by tony hopkinson

To have access basically just do it for you.

You should have a table called breeds with a BreedID (autonumber will do) and a nice name, Then change your input table from Breed to BreedID. Hit F1 for help on looks ups and it should be easy.

To use access well for lookups, master detail etc, you have to normalise, otherwise it gets really confused.

To be right Customer should be an ID (they could have more than one pet), PrimaryGroomer probably should as well if it's a member of staff, they can Groom more than one pet.

This discussion is closed to new replies.