Logic Question regarding relation

Next Question :slight_smile:

Which setting is correct for the following scenario? I have USERS and HORSES. Users OWN horses, but other users have access to specific horses for riding purposes. They have a ride agreement.

E.g. USER A owns HORSE 1, USER B can ride HORSE 1 but does not own it. USER C owns HORSE 2 and HORSE 3. USER D can ride HORSE 1 and HORSE 3.

So the USER with ride agreement should be able to select the HORSE for appointments but thats all. No full access to change profile or so.

You need two relationships. One is a horse-user ‘owner’ relationship. A horse can have one owner, an owner can have many horses.

Secondly you need a horse-user ‘rider’ relationship which I would imagine would be many to many relationship.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.