This appears to be a portal. If these are repeating fields, you have a bigger problem to fix first.
Add a calculation field to the portal's table, cDiscountedExtendedPrice as:
If ( Discount = 1 ; ExtendedPrice )
Then define the Discount total as: Sum ( PortalTable::cDiscountedExtendedPrice )
Thankyou very much - that was perfect.
Could you explain to me what a portal is and why my question is a portal. I was never tought FileMaker, always experimented, but still produced some excelent results.
A portal is what you have on your layout. This is a "window" inside your layout used to display related records. Each row of data in a portal is from a recod in the related table.
Sometimes a layout is set up with repeating fields and while this will look and function very similar to a portal, a portal is nearly always the better design option. My answer assumed that you were using a portal and so I said what I said as a way to confirm with you that this is truly the case.
You can learn more about portals by looking up the term in FilMaker help.
Thankyou very much for your definition! Very helpful!
I have one other quick question, how do I disable a field for entry unless a checkbox is checked. So again, this is what I would like except in the correct format:
If checkbox1 = 1 then enable field1 else disable field1
I have attached a picture of the two fields I am reffering to.
Simplest solution is to use a script.
Set up an OnObjectEnter Script trigger to run this script:
If [ IsEmpty ( Yourtable::PaidCheckbox ) ]
Go to next field
When the user clicks on or tabs into the field, this script jumps the cursor to the next layout object in the layout's specified tab order.
In some cases, you may want to use go to object instead of go to field. This step requires that you use the Name box in the inspector to give an object a name before go to object can put the "focus" on that object.
Thankyou very much! You have been a great help for me! I have already used what you have tought me to create another portal!
Thank you very much