Transferring Data into a Checkbox Set
Hello, I'm new to FileMaker and I'm just trying to get my head around one or two things whilst importing data from an Excel spreadsheet.
On the spreadsheet were four columns specifying which mailing list a contact was subscribed to. A "1" was entered into the appropriate field to indicate that a contact was subscribed to a particular mailing list. In my new FileMaker database a Checkbox Set seems to be a much better way of holding this data, however I currently have the imported data in separate fields which I somehow need to transfer into my new Checkbox Set which has the option of the four mailing lists.
The problem is I have over 3000 subscribers and don't really relish the thought of having to click a checkbox for each one. Is there some way (perhaps a script?) that I specify that if a field has a "1" in it then a checkbox should be checked?
Sorry if I haven't made myself clear, please just ask!