Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compound Unique Indexing

Status
Not open for further replies.
JJman

JJman

Technical User
May 8, 2003
89
0
0
IN

Can anyone tell me how to set up compound unique indexes in A2K (as opposed to compound PK's)? I've heard there is a way but can't find information on it in Help or any books. Thanks!

 
Sort by date Sort by votes
Hi, in table design view go to View>Indexes or the button that looks like a lightening strike. Enter an index name and, like macro naming, any fields you enter to the left before the next index name will be including in that index... HTH, Jamie
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

supportsvc
  • Locked
  • Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
36
supportsvc
supportsvc
Moss100
  • Locked
  • Question
Return single result for each unique record ID
Replies
1
Views
20
MajP
MajP
Moss100
  • Locked
  • Question
Confused - unique records query 1
Replies
1
Views
18
SkipVought
S
hansretallick
  • Locked
  • Question
Problem with unique records
Replies
3
Views
50
dhookom
dhookom
lameid
  • Locked
  • Question
Can't update field in unique index because intermediate values conflict with existing rows
Replies
6
Views
23
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top