Recommended table structure for tracking Opportunities and Estimates that have Items and Item Groups

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
Here are the tables I have so far...

Opportunities
Opportunity Line Items
Estimates
Estimate Line Items
Items
Item Groups

I need to be able to add Item Groups to an Opportunity. Then, when I create the Estimate, I need to be able to see the Items that go with the Item Groups on the Opportunity. 

Any thoughts on table structure and relationships are appreciated.
Photo of Minda M

Minda M

  • 466 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
I think that we probably will end up talking off-line about this but I do know how to set this up with about an hour of set up time. Basically what you want to do is put your opportunity quote and focus for that particular user.

Sometimes I call this my "shined the light" method. Basically we push a button and it either edits or adds a record to a table of users where the key feel this user. Then using a relationship where the reference field on the right hand side is the current user by formula we can flow that focus opportunity down to any child table that we need.

Then that button writes the record ID of the opportunity to that record. That That allows us to have the opportunity "lit up" for that particular user. That light then flows down to the groups which are on the opportunity which flows down to the group items which then flows up to the items. So now we have the items illuminated and when we are going to add an estimate we can pop up a report which only offers up the illuminated items.