Hi Gurus,

Struggling with this one.

I have a raw materials table, suppliers table and a join table between them of rawmtrlsupplier.

While in raw materials table, user can add one or more suppliers for a particular raw material, and see this in a related portal. I have that working fine. In the portal of suppliers I have a field "rawmtrls_RAWMTRLSUPPLIER:: _MainSupplierID" with a checkbox set that has a value list of "1". It also has a button applied to it as shown below:

Scripts: Set Default Supplier

Set Error Capture [ On ]

Set Field [ RawMtrls::_kf_DefaultSupplierID; rawmtrls_rawmtrlsupplier_SUPPLIER::__kp_SupplierID ]

Refresh Window

This works fine and I get the supplier ID that I want for other uses, but the issue I'm having is the checkbox does not display the checkmark. I do have a fill and line on the checkbox so I know that is not the issue.

What am I missing here?

if the field is a button, you cannot enter it - so the script runs, but the field is not modified. I don't think you need this field anyway - you can use conditional formatting to indicate the main supplier.

OK I finally figured it out! For those who read this thread looking for a similar answer it is this:

I needed to add a calculation to the RAWMTRLSUPPLIER:: _MainSupplierID field.

The calc is this:

If (rawmtrls_rawmtrlsupplier_SUPPLIER::__kp_SupplierID = RawMtrls::_kf_DefaultSupplierID; 1; 0)