I am new to FM and working with a DB that was created a long while ago. I figured how to do mass import but I have trouble with one of the fields.
The field name is Keywords2005. In the record layout view, it displays in an edit box (which is not editable because the box acts as a button to fire the script Go to keywords2005 which opens keywords2005 field's layout view) the values checked in keywords2005 field's layout view (each record can have several boxes/values checked for that field).
In Excel I have one column named Keywords2005 and for each record, I enter in that cell all the values (value, Alt+enter, value, etc.) that should appear in the display edit box on the record layout view and checked in the keywords2005 field's layout view).
When I import the records, I can see the values properly displayed in the record layout view Keywords2005 edit box. However, if I click the Keywords2005 edit box to access the field layout view, none of the check boxes are checked.
I suspect that I cannot upload from Excel one cell with multiple data to a field containing multiple check boxes. How to do this properly? Thank you!
|Value List Name= Keywords2005||Source=From Field||Values= Field: "Files::Keywords2005"|
|Value List Name= Kewordsnew||Source=From Field||Value="Green","Blue","Red"|
Layout Keywords2005, Keywords2005 field setup:
Display as: Checkbox Set
Display values from: Keywordsnew
Script: Go to Keywords2005
Set Field[Graphics::Layout Number; Get(LayoutNumber)]
Go to Related Record [Show only related records; From table: "Files"; Using layout: "Keywords2005"(Files)]