I have an issue in relationship two forms, for example I have the follow scenario:

I have a table who holds some users and it is called "USERS"

I have another that holds locations and it is called "LOCATIONS"

I have another table who relation both tables and it is called "LOCATIONS_USERS"

And When I try to make a Lookup for "LOCATIONS_USERS" in another form, the user defined fields doesn't appears, Why?????

Please advise...