How to use one table twice in another table.
I'm making an registration db, there every user registrate them self in an registration form. This registration is forming the user table that I use in an other table as a lookup for the users calculated surname and last name.
I need to use this user table twice in the same table, in other words you need to lookup two different users in the other table. So the primary key in the other table will have relations to two users at the same time.
One solution, is that the users have to register two times in two user tables user table1 and user table 2, but that seems pretty awkward.
Another solution may be to copy user record from user table 1 into user table 2 by using VBA. If so, then how to make the code in VBA?
Therefor I wonder if there is an other more simple way to accomplish the outcome?