Forum Discussion

MuhammadGhazali's avatar
Qrew Trainee
5 years ago

Unique Identifier on Multiple Fields

Is there a way to set up your Unique Identifier (key) based on multiple field combination? i.e., If I have fields User and Date, I want to restrict to have a specific user on a specific date only once. Same user should only have one record with same date in that table.
In most databases, that's pretty much standard feature to define your own Key based on combination of fields, but could not figure out how to handle this in QB. Any thoughts?
Thanks in advance.

Muhammad Ghazali

1 Reply