Try: Set it up as a multi-field (on E58# and Item# fields)
How do you do that? I've only seen indexes on a single field with my
2k Access.

You could also set it to ignore nulls.
Same question.



On Thu, 14 May 2009 12:50:10 -0700, Fred
wrote:

BTW, I personally wouldn't use a # sign in a field name, but if it works.......

Try: Set it up as a multi-field (on E58# and Item# fields) index, not a
multi-field key. Set unique to Y. You could also set it to ignore nulls.