Jump to content
Sign in to follow this  
Carmelo

Please help me :( Portal and Info in Same Layout

Recommended Posts

I would like to thank everyone ahead of time for the help they give on this forum.

If you could help me out, it would be appreciated.

I have 3 tables: Location, Bid Items, and Location Estimate.

In Locations, I want the address of the work, and some random comments.

In Bid Items, I have 3 different bid items for three different types of work with their respective prices, unit of measurement, and specific codes.

Now the tricky part:

I have a Location Estimate table where I want to mingle all of them. I want to be able to on the top of the screen pull up a location by a pull-down screen, then on another pull-down field pick a bid item. Once the bid item is selected, its respective price will come up and then I can enter a quantity--which will automatically calculate a total price for that bid item. Now I got all of that so far.

My problem comes into when I finished putting information for my first bid item for my first location, when I want to put in a second bid item for that same location, it shows up in the portal but it does not specifically keep the "bid item name" in the field. If I put a new bid item in on the second record, it keeps the first bid item unit price but changes the name to the second bid item name. And if I put a third bid item for the same location, the first two keep its price and quantity but changes to the third bid item's name.

I would like to see:

Location Bid Item Name UOM QTY Bid item Total

1 1 concrete sy 5 100

1 2 asphalt sy 5 80

1 3 Sidewalk sy 5 40

Instead of:

Location Bid Item Name UOM QTY Bid item Total

1 1 concrete sy 5 100

1 2 concrete sy 5 80

1 3 concrete sy 5 40

Sorry for the long post, hope I explained it correctly.

Share this post


Link to post
Share on other sites

Usually, When you are having problems with data within portals it has something to do with your relationships. Since you don't mention that you even have any relationships defined I would start there. Perhaps you would like to post a clone of your file or at least explain your relationships.

Share this post


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
Sign in to follow this  

×

Important Information

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