Jump to content
  • 0

Search Results based off multiple tables


Psquare1

Question

Thanks in advance for any assistance. 

I am trying to get results based off employer and location. Here is an example:

Table 1 (Company):

Employer_1, Employer_2, or Employer_3. Location is Business_Zip

Table 2 (Customer):

Employer_1, Employer_2, or Employer_3. Location is Customer_Zip

When submitting a request form, the customer can request an answer from Employer_1, Employer_2, and/or Employer_3. The request will go to the Company with the matching zip (IE: Business_Zip = Customer_Zip)

Here's where I'm stuck. I need to create a workflow that directs the question to the correct Company, based off matching Employer and zip.

It would look like this: Customer completes the submit form, and request the information to come from Employer_1 and Employer_2. When Employer_1 w/ matching zip logs on, it will show the request, same for Employer_2 w/ matching zip, however Employer_3 + Employer_1 without matching zip + Employer_2 without matcing zip, will not show any data. 

I apologize for the extreme detail. I've been through the forums, online videos, and help questions for over a week now. I probably need to step away, but this is one of the last steps before I can launch. Thank you again!

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
On 12/2/2016 at 4:44 PM, Ariel said:

Hi Psquare1,

Are Company_1, Company_2 and Company_3 separate fields in both tables?

Can you please provide some more detail on this part: " however Employer_3 + Employer_1 without matching zip + Employer_2 without matcing zip, will not show any data.  "

Thank you,
Ariel

Hi Ariel,

Yes, Company_1, Company_2, Company_3 are separate fields on both tables.

As an example for the second part, "John (customer) is purchasing a widget. A similar widget is offered by three stores, whom all have multiple locations. John's question would need to go to any of the three stores he has requested information from, and to the closest location to John, of the selected store(s)."

Link to comment
Share on other sites

  • 0

I am trying to understand your data.

You have customers.

You have Companies.

  • If customer orders for customerzip=12345 from employers e1,e2,e3 then request will go to employers e1, and e2 with matching  zip code = 12345 Request will not go to e3 because zip is not matching
  • If customer orders for customerzip = 12341 from employers e1,e2,e3 then request will go to all three e1,e2,e3 because there is matching businesszip=12341=customerzip=12341

Let me know if this is the setup of your data.

Thanks,

Neal

NealPatil @ gmx.com

 

Customers.png

Companies.png

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...