[AccessD] Circular reference error in query...

Bobby, 

Test by destruction. Remove all relationships defined between the to
tables, and test. If that isn't the problem, drop the primary index on
wrkSearchAvailable, and run the query again. If that doesn't make the
problem go away, drop another index, and try again. If no joy, remove
all required field settings, and retry. If that still doesn't work, drop
fields one by one and retry.

The last thing you removed before the errors stopped is the thing that
is causing the problem. Examine it more closely, and the solution will
become apparent.

-Ken

PS. It looks like you only need an autonumber ID on wrkSearchSelected.
wrkSearchAvailable should have a plain Long datatype (no autonumber) for
the ID field so it can properly reference the original record in
wrkSearchSelected. Hmm... Why do you need any fields in
wrkSearchAvailable other than ID? It doesn't look like any of the fields
copied to wrkSearchAvailable have data that should be changed, so why
not just refer to them in wrkSearchSelected?