Thanks it worked great.
I assume in the future if I have 14 fields in one table I will have to manually input each one:
alter table maintable
add constraint maintable_myNamehere unique (valdata, fid, fid2, fid3, anotherfld, another2, another3, another4, another5, another6, another7...