Lookup Information

[Jorge]

I have 3 DB's

DOG.db, CAT.db, RECV.db

DOG has Food$, Carrier$, Shots$ Primary key = A
CAT has Food$, Carrier$, Shots$ Primary key = B
These 2 db's can only have one entry pertaining to food etc
So would you call these a table? I suppose.
I have the record set to 1.

RECV has Name, Address etc.. and type of transaction (DOG or CAT)
Based on a check mark (on/off) in DOG or CAT it will display the current
fields within either Dog or Cat for Food$, Carrier$, Shots$
Does this sound okay?

|X| | | -------------------------
DOG CAT | Dog Food $5 |
| Dog Carrier $5 |
| Dog Shots $5 |
| |
--------------------------

The dog & cat & Recv databases have quite a few more entries but I am just
trying to keep it simple.

Thank -u
Jorge

 

[Jorge]

Perhaps I should indicate my question for below?
HOW do you get the unbound box to display the results after Dog or Cat is
checked?

Thank-You