I'm trying to devise a simple method to import form data (prbably from multiple Word docs) into a FM database. Is there an easy way to have to have FM look at a group of fields in the import data and enter one value based on which checkbox was marked? The Word form has 4 checkboxes, which export as individual fields with either 0 or 1, while the DB has just one corresponding field with the value entered as text. Do I have to set up fields in FM that match the ones from Word, then create 4 calc fields that pass text to the one field that I want filled in?

Any general pointers about importing form data appreciated.

Importing into FM requires a one to one correspondence for the fields. So, you will have to have bring the checkbox fields into separate fields, and then convert them with a script or a calculated field.

I have been able to import to a group of checkboxes by separating the corresponding value field entries with a newline character.

For instance, If your FM checkboxes have a value list like this:

Male

Female

Both

Neither

Other

and you want to have the Male and Other boxes checked, you can import the following to the FM field:

Male

Other

which will check the first and fifth boxes.

I wish this worked for repeating fields, but it doesn't.

Please note that I am using ODBC and not importing from Word, so this may not apply to you, but I have been able to populate multiple checkboxes in a group from a tab or text delimited file as well.

Michael