If you have a multiple choice field marked as Unique, you are going to be limited in the number of records you can create on that table. Example: You have a Yes/No multiple choice field that is required to be Unique. Once you have a record that has Yes selected, you will not be able to create another record with an answer of Yes. If you did, then it would not be Unique. Is that your intent?
If you try to copy a record with a Yes value from one table to another and there is already a Yes value in an existing record in the new table, it won't copy because this would cause a duplication.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 /
http://datablender.io/------------------------------