Bento > Filemaker > Checkboxes
apologies for asking such a stupid question, but although I know databases and how they work I just don't get the problem fixed and I assume it shouldn't be as difficult.
The problem is, I have used Bento for a while until I have decided to switch to Flilemaker, the conversion went well, but I ended up with loads of numerical fields which used to be lovely checkboxes. :)
Can anybody guide me - dummy that I am - how to create checkboxes out of these numerical fields which contain 0 and 1 as values?
Any help greatly appreciated, I've gotten grey hair about this. :)
You can use the inspector format these number fields as checkboxes and use a value list with just 1 as its only value. Then fields that contain a 1 will show a selected check box and fields that contain any other value will show an empty check box.