I have two layouts one for rat based by project and one for invoicing. The invoicing portal should pull rate from the rate portal associated with the same project. Instead it only shows the data from the first portal record in rates. any help will be great.
Here is the relationships
Here is main page with invoice detail portal and rates portal
Here is my invoice detail with my invoice detail portal
Here our my invoice detail portal fields with calculations for Hourly, daily, weekly and monthly price.
You should link the Rates to InvoiceDetailPortal by RatesID.
Then it will evaluate according to the item.
The context is such that you will always get ( "look at" ), the first related record ( influenced by sort order of the relationship in the graph ).