August 29, 200124 yr Hi people I have a question. I've got five fields in this old database of mine in Clarisworks 4.0 format which I want to import into one field in filemaker that is a checkbox style value list. Any idea of how to do this with no hassles? Thanxs Steve Griff
August 29, 200124 yr You will need to import the five fields into five fields and then build your combined field with either a looping script or a stored calculation (it can be turned back into a text field and the other fields deleted as the last step). The calculation will look like: CombinedField (calculation, text) = Field 1 & If(notIsEmpty(Field2), "
Create an account or sign in to comment