I have 3 tables:
memberFk FK to member(id)
membershipFk FK to membership(id)
The rule is 1 member can have 0…N membership. If he or she join membership, it will be stored on membership_group table.
My problem is,
I have to define relationship from a member to membership, to display all memberships that a member ever joined.
I also need a relationship from member to membership to show the latest membership he or she joined, membership is sorted by startDate.
Any one can help? Is it possible to have HAS_ONE and HAS_MANY at the same time?
Thanks in advance.