Darren Bartrup
Well-known Member
- Joined
- Mar 13, 2006
- Messages
- 1,296
- Office Version
- 365
- Platform
- Windows
I know if I set two fields as Primary Keys then the combination of those two fields cannot be duplicated within the table.
Is there a way of achieving this without setting the fields as Primary Keys?
I have a table with four fields:
<tbody>
</tbody>
A combination of sPostalSector and lBranchID field cannot be duplicated.
As sPostalSector is text I'm pretty sure it's not the best idea to have it as part of a Primary Key.
Any help would be greatly appreciated.
Is there a way of achieving this without setting the fields as Primary Keys?
I have a table with four fields:
ID | AutoNumber and PK |
sPostalSector | Text |
lBranchID | Number |
lGroupName | Number |
<tbody>
</tbody>
A combination of sPostalSector and lBranchID field cannot be duplicated.
As sPostalSector is text I'm pretty sure it's not the best idea to have it as part of a Primary Key.
Any help would be greatly appreciated.