Multiple Indexing

You may be better off using a hammer rather than a spanner.

I would suggest that you read up on normalisation and then apply that to
your data. You may wish to check the Access 2002 Knowledge Base article
283878 dated 10 October 2003. (Referenced on MSDN Library DVD July 2004) or
online at http://support.microsoft.com/?id=283878

--
Slainte

Craig Alexander Morrison


"CVL" wrote in message
...
Ok. So your saying the blank entries is the problem.

Why then when I create a new database and have 2 fields only plus a
primary
key, multiple index the 2 fields and enter in details for both the fields
on
every record does it still record say:

"Test, Test" and "Test, Test".

Is there prehaps an option in Access or an extra item I require to install
to run this properly?

Is there another way of ensuring the same value does not get entered into
the 10 fields throughout the database?

eg "Test" cannot be placed on another field on the record OR on another
field in ANY record.

John you seem to understand exactly what I am trying to accomplish. However
the problem is that I am selecting the indexes icon, I am selecting one name
and then the fields and I have set the index to unique yet it ignores the
index completely as if it was not there.

I will look further into possibly making another table and for the fields.

As for a design flaw with the data only being entered once it is because of
the data that is being delt with. The 10 fields are dealing with vehicle
registration numbers, because we can not work on a single vehicle more than
once these entries will not need to be used again.

It is particularly tempting to use a hammer against this problem I must admit.

I know normalisation is to remove many to many relationships, however these
fields dont include a relationship at the moment because it was not needed.

However if I try to go around the problem and create another table this will
become neccessary.

On Thu, 2 Sep 2004 03:17:06 -0700, CVL
wrote:

John you seem to understand exactly what I am trying to accomplish. However
the problem is that I am selecting the indexes icon, I am selecting one name
and then the fields and I have set the index to unique yet it ignores the
index completely as if it was not there.

On rereading the thread, it seems I did misunderstand. Do you mean
that if the value A123321 occurs in ANY of the ten fields, in ANY
record, then it should be prohibited in any field in any other record?

If so, a) an Index will not help and b) as suggested by the other
volunteers here, your table structure is INCORRECT and should be
revised.

John W. Vinson[MVP]
(no longer chatting for now)

=?Utf-8?B?Q1ZM?= wrote in
:


I will look further into possibly making another table and for the
fields.



If you are able to tell us a bit more about what you are trying to achieve,
we may be able to help. I see that the other half of this thread is coming
to the same conclusion!

B Wishes


Tim F