Setting an Index Value

B

Betsy

I have an index based on two different fields. I want to be able to set its
"Unique" property to True or False based on a value in another field. Is this
possible?
 
M

Marshall Barton

Betsy said:
I have an index based on two different fields. I want to be able to set its
"Unique" property to True or False based on a value in another field. Is this
possible?
Click to expand...


Absolutely not! An index applies to the entire table, not
to a subset of records.

Perhaps you want to include that other field in the Index
too??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Making a macro only work on certain files 2
Autonumber field in Excel that behaves the same as Access 0
Finding the right style field in VBA 0
Change a great number of words in word files, with a macro as short as possible. 5
Insert Index into a Table 1
Split form 0
Link a text box based on drop down box with four options MS Word 365 0

Top