Jump to content

Recommended Posts

  • Newbies

Hello, I was hoping to get some help with a Sales database.

I have a table called "Worksheet" that the user will be working from.  There is a portal that pulls up items to sell and allows the user to select different options for that item.  The table that has the items as records contains multiple items of the same name, but different options.  For instance, there are two items called 1" Flanged Nozzle.  One of those items has a 50 PSI option and one has a 150 PSI option.  Each option has a different price.

In the portal on the Worksheet layout, the user can pull up the 1" Flanged Nozzle and then they need to be able to select whether they want the 50 PSI or 150 PSI option, but it only pulls up the first 1" Flanged Nozzle record and when I change the option from 50 to 150 it changes it on the actual related record instead of switching to the second record that matches all the criteria.  I am not sure if I am approaching it wrong all together, or if there is some sort of different relationship that I need to use between the related tables. 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

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