I will try to be as specific as I can here as I’m not near a computer.
So for brevity let’s say I have 3 tables.
Table 1:Animals,
Table 2: Organizations and
Table 3: Medical History.
There’s an FK relationship between Medical History and Animals, meaning Medical History has an AnimalID column. Then, the same goes for Animals and Organizations to associate every animal to an organization.
Now, when I open the Add Medical History page, I’d expect to find a drop down with a list of animals so that I may associate a medical history with that animal that belongs to that organization.
However, I’m getting a number field as it’s wanting me to enter an ID.
I’ve tried looking at different examples but not following.