Hi,
This must be do-able but I can't seem to get it right!
I have a small system in which we registrer adressen, contacts and visit information.
It;s built up like this:
adressinfo:
| |
| |
contacts visits
Now what I would like is a drop down list in the visit table where you can choose who you spoke with during your visit. Obviously this must be someone that is also in the contacts list. The moster I've created gives contacts in a drop down list but does so for the whole dbase!
How can I get it to give just the contact from the adress you are in?
Can u help me?
This must be do-able but I can't seem to get it right!
I have a small system in which we registrer adressen, contacts and visit information.
It;s built up like this:
adressinfo:
| |
| |
contacts visits
Now what I would like is a drop down list in the visit table where you can choose who you spoke with during your visit. Obviously this must be someone that is also in the contacts list. The moster I've created gives contacts in a drop down list but does so for the whole dbase!
How can I get it to give just the contact from the adress you are in?
Can u help me?