I am trying to achieve the following.
I have a main table : Deals
In that table I have a field with a popup menu that has the following options:
I have a layout with a portal that shows all records.
I am having a big difficulty setting up relationships to create other layouts with portals showing records from deals based on the pop up choice. I want a layout for "Working" and 2 separate layouts for "Under Contract" and "Lost"
How do I properly link them? I also have a primary key as the Address of the property as those are unique.
Do I need something like this?
Deals = Deals 2 = Working
Deals = Deals 3 = Under Contract
Deals = Working
Deals = Under Contract
Sorry if this is way off.