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.