Create new secondary constraint on a table using the Access UI (1 Viewer)

[GoodyGoody]

Hi, I was to create a secondary constraint on a table as a combination of 2 fields. How do I do this using the Access UI as opposed to doing it in SQL?

Thanks
Stephen

 

[jdraw]

Are you asking about unique composite index??

 

[MajP]

This requires the first name and last to be unique combination. Click on idexes. Give the index a name. Add the fields.

 

[GoodyGoody]

Ah thank you! I new it had to be somewhere. Did an Alter table in the end

 

[isladogs]

As already advised, creating a composite index on first and last name will prevent you having more than one person with the same names.
In my experience, you may regret doing that.

 

[GoodyGoody]

No this is to keep the runnerracenumber unique for a race which of course is what you want. Only one number per race.

 

[MajP]

creating a composite index on first and last name will prevent you having more than one person with the same names.

That was only an Generic example of how to create a composite index. I do not even know if those are fields in the table.

 

[GoodyGoody]

It's fine. I know what I need. Thanks for the input