Is that you have a relationship that works, and on the right side are records with data values like 'WhiterShadeOfPale', 'FortyShadesOfGreen', and 'SimplyRed', and currently on the left side is a radio button with the value list:
and it works? But you want the radio button to have a value list of:
and it will still work?
If I have understood your question correctly, then why not displace the LHS relationship field to be a calculation, based on the new radio button value list? The calculation for this NewValueToMatch would be:
RadioButton = "White" ; "WhiterShadeOfPale" ;
RadioButton = "Green" ; "FortyShadesOfGreen" ;
RadioButton = "Red" ; "SimplyRed" ;
Yes, that's exactly what I want.
I'm trying it out now but having problems.... I'm fairly new to FMP so not too familiar with the terminology like LHS relationship. Where do I add this calculation? To the field that uses the radiobuttons I would assume? And I keep my link between the two tables as is?
When I add it to my field where I'm using the radiobuttons, set to calculation with result as text but when I try it out I get "This action can not be performed because the field is not modifiable".
Make another field with the calculation I've shown.
Your existing relationship is using the 'old' (existing) radio button field and values on the Left Hand Side of its definition.
Having created the new calculated field, change the value list for the 'old' radio buton field, and change the existing relationship to use the new field on its left hand side, not the current field.
You will not be able to change the 'new' field (you don't even have to have it on a layout) as it is a calculation, but you will still be able to change the existing field.
Thanks so much. That worked perfectly.