How to return a result of a SQL query within an Event Procedure(&what am I doing wrong here)?

[Beetle]

What I found was that Access 2003 would not allow me (from what I

could tell) to set up an index for two keys where the COMBINATION of
the two keys was unique, but neither key being unique.

Yes it will. Unless your version of Access is somehow different than every
other version in existence. I explained how to do it in a previous post, and
Rick Brandt went over it again in his post. Honestly, i don't know how I
could explain it any better, but i promise you that you absolutely can set up
a compound index on two or more fields in your table, and Access will ensure
that each record must have a unique combination of values in those fields.

 

[raylopez99]

Yes it will. Unless your version of Access is somehow different than every
other version in existence. I explained how to do it in a previous post, and
Rick Brandt went over it again in his post. Honestly, i don't know how I
could explain it any better,

I know something that will explain it better, and thought about doing
this with my file, but I don't want to burden anybody: use SendFile
or some other service and post a link to a simple Access table that
can be downloaded that has--

A single Primary Key (PK) table, table A, that is migrated to (used
by) another table, table B, and,

table A having two non-primary fields that are indexed in the manner
you describe and also used by table B, with the restriction that the
two non-primary keys, when used in table B, have to be unique, in
combination but not necessarily unique singularly, as discussed in
this thread.

Until I see that I'm sticking to what I know and can use, since I've
played around with trying to make this work via keys/indexes without
success. Of course next time I plan to incorporate as a primary key
the use of compound keys earlier in the design process, but that's
another subject.

RL