DB question

weblike

I we have 2 BO's
Company
Users

Company has multiple users and the relation with User BO -> Peer(multiple allowed)

Looking into DB-> users table ...cannot see any relation between these 2 tables: no Company_RID
Am I missing something here of course.🙂

Any tip would be much appreciated.

thank you.

Jaymer

browse COMPANY_REF in SQL Tool
all you will need is in there

jaymer...

weblike

Jaymer wrote
browse COMPANY_REF in SQL Tool
all you will need is in there

jaymer...

Thank you.....
Was a blonde question 🙂

BLOMASKY

as you know, any many to many relationship requires a 3rd table. (Depending on the # of records and doubt if you have a LOT of users, proper multi-segment indexes can speed this join.

Bruce