Radio Button Selection->One or The other

[OutbackInvestments]

Hi again.

I have 2 radio buttons, BrokerFeeFlatRate and BrokerFeePercent which selects if the broker fee is a flat rate or a percentage of the total. I want to make it so that if one button is selected, the other is not. So if I click BrokerFeeFlatRate, BrokerFeePercent will be cleared, and if i then select percent, flatrate will be delselected. How do I do this. My field definitions are as follows.

BrokerTable:
BrokerID (PrimaryKey)
BrokerName
BrokerFeeFlatRate(Yes/No)
BrokerFeePercent(Yes/No)
BrokerFeeAmount(Number)

This makes it so that in a future calculation, BrokerFeeAmount is placed in front of the number and FlatRate will add a .0 to the end and percent will add a % (In my expression definition.) can sombody help with this? Sorry if it is complex, I'll simplify it if you want me to.

 

[KevinM]

Use an Option Group instead of individual check boxes (radio buttons). That way you will only ever be able to select one or the other.

HTH