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?