Table Reference

Hi there,

i have the following tables “Horses”, “User”, “Food”. A Horse belongs to a user and can have multiple food.

When in the food table i have a table reference to “Horses”, but when i want to enter the horse ID i just can enter the ID of the user the horse belongs to - not the horses ID. Its totaly wired. Does anyone knows whats wrong?

Hey messaged you back on chat. You had your auto-complete settings for pferde to display the field referencing the user on that table (Besitzer). That’s why you were seeing only the user ID there.

1 Like