Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Find records from table1 and displaying from tbl2

This topic is 5911 days old. Please don't post here. Open a new topic instead.

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.



Link to post
Share on other sites

This topic is 5911 days old. Please don't post here. Open a new topic instead.

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.

  • Create New...

Important Information

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