Copying Check Box Data

[Niet32]

I have a script that copies data from a text field that is setup as a checkbox.

The checkbox pulls values from another table.

However, when the script copies the data from the field is not only copies the checked data but any data that is currently in the field and previous data.

For example:

X Choice 1

X Choice 2

O Choice 3

The script will copy not just the 2 items checked but all 3. It then also copies any choices that may no longer be in the database.

Running FMP 11 Advanced

Any help is appreciated.

Thanks

[imoree]

This sounds like a relational issue. If your table has bad Structure, then you have all sorts of data problems. may i suggest posting a copy of your Relational Graph/ Or Database WITHOUT DATA!!

cheers,

-i

[Russell Barlow]

I have a script .....

Explain your field setup for the checkbox and what your script is doing or provide an example of your database.

Edited April 11, 2012 by Lee Smith
If you are not going to inline comment, please Do Not Quote the entire post

[Niet32]

Thanks for your feedback. Something you said made me go back and relook.

I changed the field to a global field and it resolved the copying issue.

Thanks