I would like to simulate radio button functionality with 2 boolean fields.
by that I mean, if one is set true, set the other false.
Right now I have a radio button text field with a value list containing 2 values. and the 2 boolean fields evaluate if one or the other value is set in the text field
This is a bit brittle, relying on the text field. I would prefer an auto enter calc on the fields isCustomer and isVendor but my numbers attempts have failed. I know I can script something but I prefer to bake it into the data model where I can.
Company::isCustOrVendorv is text field with radio button control with the value list Customer Vendor.
Company::isCustomer is a number field that auto evaluates if ( company::isCustomerVendor = "Company" ; 1 ;"")
Company::isVendor is a number field that auto evaluates if ( company::isCustomerVendor = "Vendor" ; 1 ;"")
1 of a few not functioning attempts -
Company::isCustomer Auto Enter Calc if( isVendor; "" ; 1)
Company::isVendor Auto Enter Calc if( isCustomer; "" ; 1)