Problem With Self Join View With 3 Tabels

[peterhanse]

Good morning, i need some help with some views, 

 

I have 3 tabels

 

I need a view whit:

 

all horses (tabel2) (tabel3 empty)

all conections horses (tabel2) (tabel3)

 

tabel1 name:users

 

field: user_id(key)

 

tabel2 name:horse

 

field: horse_id (key)

field: user_id

 

 

Tabel3 name:conections 

 

field:conection_id(key)

field:horse_id

field:user_horseowner_id (user_id)

field:user_linked_id (user_id)

[Walter]

Hello peterhanse,

 

If I were in your shoes, I'd use four tables:

 

1. Users:

id

many fields - information.

 

2. Horses:

id

many fields - information.

 

3. Ownership:

id

link_to_horse

link_to_owner

 

4. Lnked_users

id

link_to_horse

link_to_user

 

Settings of the View:

Tables are used:

Users

Users_1 (the second time)

Horses

Ownership

Linked_users

 

Relationships:

Ownership.link_to_owner (include all records) = Users.Id (include only matching records)

Horses.id (include all records) = Ownership.link_to_horse (include only matching records)

Horses.id (include all records) = Lnked_users.link_to_horse (include only matching records)

Lnked_users.link_to_user (include all records) = Users_1.Id (include only matching records)

 

Is it the correct View?

[peterhanse]

Yes it works, thank you