Caliban1971
New member
- Local time
- Today, 18:19
- Joined
- May 10, 2011
- Messages
- 4
Hi.
This may be an easy one, but I can't seem to figure it out. I have a query that pulls data from 2 tables based on criteria selected from combo boxes in a pop-up form. Here is a brief discription of the tables with the most relevant field for my question:
Table 1: Employment History: Field=Job Title
Table 2: Customer Engagement: Field= Engagement Type (phone, email,etc)
The idea is that we get customers from a variety of occupations (table 1) and then engage them, either with email, phone, or in person (table 2). The main customer demographic info (name, address, etc.) is in a separate customer table.
If I query for an occupation and there is a related field in Engagement, it will show them. But if there has been no engagement, if I have an occupation but didn't do any entry for them in table 2, it will return no values. For example:
Table 1 has 3 RN's, and each has a related engagement in Table 2. So the query will show those RN's.
Table 1 has 3 LPN's, but they don't have any related engagement in Table 2. The query returns no values. It looks as if I have no LPN's.
The purpose of my query is to easily filter through all the occupations, and get the relative info about their engagement, whether or not there is any engagement.
Is this possible? Sorry it is so long. Any help is appreciated.
Michael
This may be an easy one, but I can't seem to figure it out. I have a query that pulls data from 2 tables based on criteria selected from combo boxes in a pop-up form. Here is a brief discription of the tables with the most relevant field for my question:
Table 1: Employment History: Field=Job Title
Table 2: Customer Engagement: Field= Engagement Type (phone, email,etc)
The idea is that we get customers from a variety of occupations (table 1) and then engage them, either with email, phone, or in person (table 2). The main customer demographic info (name, address, etc.) is in a separate customer table.
If I query for an occupation and there is a related field in Engagement, it will show them. But if there has been no engagement, if I have an occupation but didn't do any entry for them in table 2, it will return no values. For example:
Table 1 has 3 RN's, and each has a related engagement in Table 2. So the query will show those RN's.
Table 1 has 3 LPN's, but they don't have any related engagement in Table 2. The query returns no values. It looks as if I have no LPN's.
The purpose of my query is to easily filter through all the occupations, and get the relative info about their engagement, whether or not there is any engagement.
Is this possible? Sorry it is so long. Any help is appreciated.
Michael
Last edited:
