I have a quoting application I'm working on.
There are upcharges to the quote. Generally following: Relational Database Design with FileMaker Pro with Cris Ippolite on LYNDA.com.
Trying to use the portal to add new line items to the quote.
primary and foreign keys are connected on relationships
relationship between Quotes and QuoteUpchargeLineItems has "Allow creation of records in this table via this relationship" checked.
Poral added. Display looks fine.
QuoteUpcharges:__pkQuoteUpchargeID, QuoteUpcharges:__pkQuoteUpchargeID, QuoteUpcharges:FlatCharge, QuoteUpcharges:RunCharge, QuoteUpchargeLineItems:Quantity.
Made valuelist for first field.
When I try to change one of the UpchargeID with the pop ups I added, I get :
This action cannot be performed because this field is not modifiable.
When I select the empty bottom row, I don't even get the popup.
Please advise if what I'm missing.