autofill variable query - help needed !

A

AlexT

Folks

Not quite sure how to tackle this one...

I have a table, say OBJECTS, for which I have to maintain a status on a
record by record basis for each user (in a multi user environment).

As such I have designed a table with a link to OBJETCS's primary key,
the user name and the actual status


!-------------------! !-------------------!
! OBJECTS ! ! STATUS !
!-------------------! !-------------------!
! objIdx ! 1 --- n ! statIdx !
! ! ! statUser !
! ! ! statValue !
!-------------------! !-------------------!


Now I'd like to design a query that will populate the STATUS table
taking as a parameter the username.

Typically I would call this query when a new user is added to the
system and I have to generate the corresponding STATUS records.

I now how to do via ADO/VBA loops but I'm looking for something more
elegant... hence my post here :)

Any suggestion / comment welcome

Regards

--alexT
 
Top