Jump to content
Sign in to follow this  

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

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.