user18951

Portal confusion - adding records

Discussion created by user18951 on Dec 21, 2012
Latest reply on Dec 23, 2012 by user18951

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.

 

relevant structure

 

Tables:Fields

 

Quotes:__pkQuoteID

 

QuoteUpcharges:__pkQuoteUpchargeID

QuoteUpcharges:Description

QuoteUpcharges:FlatCharge

QuoteUpcharges:RunCharge

 

QuoteUpchargeLineItems:_fkQuoteID

QuoteUpchargeLineItems:_fkQuoteUpchardID

QuoteUpchargeLineItems:Quantity

 

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.

 

thank you.

Outcomes