unique multicolumn

[SamLis]

Hello,

I have 3 tables

tbl1 :
NameID
Name

tbl2 :
CatID
Category

tbl3 :
ProdID
CatID
NameID
Remarks

How can I avoid duplicate records in tbl3? Since remarks can be Null?
product is later used in tblInventory...

thanks,
Sam

 

[SamLis]

hi,

The data was imported from excel, I assume that the empty fields are Null?
I found some tips of changing

the default value : ""
allow zero length

but ths not working for me, probably because of the data already in the table?

Or is there a way to validate this on form level for new entries, since I cleaned up the excel.

Sam