Thread: a table with 2 relationships with the same table

I have a table that has names of people in it.

The info in that table can form a relationship with another table in two different ways. how can i do that?

an example would be:

tblNames.FieldName to tblAsset.FieldOwner

tblNames.FieldName to tblAsset.FieldBorrower

FieldName means the the field Name (yes i know that is a reserve word. this is just conceptual)

If I want the same names to be borowers as owners (depending on the circumstances) then I would need to use the same table or at least copy from one to another when a new name is added or deleted.

Thanks so much. As it turns out I was just thinking too much. I implimented the concept on a much smaller database to isolate it and it was very simple. WIth alot of other things going in the database I want to use it in it seemed complex. I was just over thinking.



Thanks