Jump to content
Sign in to follow this  

Find records from table1 and displaying from tbl2

Recommended Posts

Ok, Now I am really lost. I have two tables that are imported from csv files. These tables are fairly straight-forward in that one hold a price for service,by service provider,location and region.

I want to use table 1 as a search, for a specific service provider in specific state, in a specific region. This should display a price for those vendors in: 1. NY state

2. In the NE region

The last field on that page is the max. cost for the region/area that we can pay for the service.

I would like those results to be piped into a new table I have already set up that add 2 more fields to the list. One is a client Number and the other is a dropdown that allows the users to let us know if they selected the provider and for what reason.

It seems really complex, but I might just be over thinking the entire thing.

Any Help would be great.



Share this post

Link to post
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.

Reply to this topic...

×   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.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.