Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 470
  • Last Modified:

Index No Duplicates - Foreign Keys

Hi Experts,
How do i go about in setting up an index for two foreign fields.

Is it just a matter of selecting Index: Yes (No Duplicates) for the two fields?

In this case the two fields would be ClassProductID and ClassDate.

Thanks

IndexNoDuplicates.jpg
0
Ronniel Allan Castanito
Asked:
Ronniel Allan Castanito
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
See the attached example

open table in design view
View>>Indexes
Give the new index a name, MyIndex in this example
Pick the Field Names
Click back in the first row (SeqNumber in this exampe)
Set the Unique property to Yes in the Index Properties window.

"Is it just a matter of selecting Index: Yes (No Duplicates) for the two fields? "
No.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Opps ... now attached.

mx
Capture1.gif
0
 
Ronniel Allan CastanitoIT ManagerAuthor Commented:
Thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now