问题描述
我有一个包含年份字段和票号字段的表。两者合起来制作我们的全票号码。所以一个例子是
年场 - " 09-"
ticketnumber字段 - " 0001"
完整的票号将是09-0001
我想知道的是（如果我的条款不正确，我很抱歉）可以链接这两个字段，以便条目必须是唯一的。因为当2010年到来时我们将再次使用0001，所以我不能让ticketnumber字段独一无二。所以我想知道我是否可以在两个领域都有独特的条目...我希望我解释说足够的大声笑...如果有人有任何建议，将不胜感激。谢谢！
i have a table that has a year field and a ticket number field. the two combine to make our full ticket number. so an example would be
year field- "09-"
ticketnumber field- "0001"
the full ticket number would be 09-0001
what i want to know is (and im sorry if my terms are incorrect) can i link the two fields so that the entry has to be unique. because when 2010 comes we are going to use 0001 again so i cant just make the ticketnumber field unique. so i wanted to know if i can have the unique entry look in both fields... i hope im explaining that enough lol... if anyone has any suggestions it would be greatly appreciated. thanks!
推荐答案
这篇关于独特的入口的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！