Stuck in the mud again. I have set up a DB that looks up Card ID 1, Card ID 2 and Name from Customer Table and places it in the a portal from CheckIn Table. This works just fine. But, Is there a way to enter Card ID 1 or Card ID 2 in the Enter ID field and pull up the same info. See Attached.

Any help would be appreciated.

LookUp.zip

Please clarify a few points:

1. How many cards can one customer have?

2. What's the difference (if any) between Card1 and Card2? Are there two types of cards, or are they the same?

3. Do all cards have a unique ID (i.e. no Card1 and Card2 with the same ID)?

Each customer can have up to two cards. There are two types of cards. One is a smart card with a chip and the the other card is membership card ( Gold or Silver ). Some customers have both types and some of them have smart cards and some only have membership cards. The membership card numbers start with one or two letter like G,S or MW.

I'd probably have a table for the cards anyway, just for good order. If these cards ever expire or get transferred to a new member, such table is a must. If not, you could probably get by with the attached shortcut.

CheckInS.zip

Why are there any lookups?

LookUp.fp7.zip

Thanks All.

BruceR, that’s just what the Doctor ordered. And as for the lookups, at first there was only one customer card and it worked. But, I do like this better.