Hi there,
Is it possible to set up a table so that no one can enter duplicate data for an entire row?
Example of what I mean
Stats_tbl
id field
Username field
Date field
other field
The 4 fields above will often have some of the same data appearing in them. Another words username field will have the same name apearing, but on different dates.
What I want to make sure of is that no one enters the exact same information that is in one record of the table, as another record of the table.
Hope that makes sense.... :?
Is it possible to set up a table so that no one can enter duplicate data for an entire row?
Example of what I mean
Stats_tbl
id field
Username field
Date field
other field
The 4 fields above will often have some of the same data appearing in them. Another words username field will have the same name apearing, but on different dates.
What I want to make sure of is that no one enters the exact same information that is in one record of the table, as another record of the table.
Hope that makes sense.... :?