By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,223 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Relationships - determining a contact person based on 3 fields in table.

P: n/a
My database contains three tables. 1. A table of state contacts, 2.
regional contacts, and 3. Application information.
tblApplicationInformation includes the following fields
[ID],[AppType],[ProvType], and [FacState]. I need the database to be
able to automatically figure out who the state contact is and who the
regional contact is based upon [AppType],[ProvType], and [FacState].
These 3 criteria will select a single contact from tblStateContacts
and a single contact from tblRegionalContacts. What is the best way
of doing this?
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.