auto enter through portal with unexpected behaviour

[FMApps]

Im sure this is something simple im missing.

Im sure this is a common enough

got a layout "orders" with a portal "line items". When a serial is entered into the portal the line items should use the serial to LookUp the price from a related inventory table. The LookUp is calculated (needs to be because there is more than one price depending on a parameter). The first item added to the portal leaves the lookup blank all other after work fine. Also works fine if you remove the first portal record and reenter it.

help would be appreciated

Thanks

[comment]

The LookUp is calculated (needs to be because there is more than one price depending on a parameter).

Please describe exactly how you set it up.

[FMApps]

here are the relationships

relation.pdf

lookup calculation is in the line items table

Price field does this lookup calculation. tried with both option checked and unchecked (replace) and (dont calc if fields empty)

Case(

Customer::tier=1;Inventory::Price Tier 1;

Customer::tier=2;Inventory::Price Tier 2;

Customer::tier=3;Inventory::Price Tier 3

)

as i said before this woks after one entry has been made even if its removed.

I appreciate the help

[comment]

I believe it works after the Order record has been committed. This is a known (and ongoing) bug. You can use a triggered script to work around it.

[FMApps]

I believe it works after the Order record has been committed. This is a known (and ongoing) bug. You can use a triggered script to work around it.

Thanks problem solved