AnsweredAssumed Answered

Show one thing in form but write different to the database.

Question asked by glyoung on Feb 22, 2012
Latest reply on Feb 23, 2012 by comment

Newbie, coming from .Net programming and SQL background.

 

I have 5 fields that store a 1 or 0 in them. I have tried making these part of a radio button group and for the one item you choose that field would get written as a 1 and all of the others as a 0. But it seems that radio buttons are just stored in one field in Filemaker Pro.

 

Another option I have tried is to have them just all be drop down boxes. Is there a way to show a Yes in the box, but have it actually write 1 to the database instead of Yes or no?

 

Any help is appreciated.

 

Ginny

Outcomes