Foreign key confusion
I have a normalized relational database. For example I have a particular type of Vendor associated with a Tissue type (i.e. Lonza supplies a Tissue named Hela).
The Tissue table has its own primary key, and the primary key for the Vendor table is a foreign key in the Tissue table. There is also a similar primary key/foreign key relationship for Organisms (i.e. Homo sapiens, Mus musculus etc) in the Tissue table as well.
My goal is to be able to create a composite sample entry point that would enable me to select the Vendor or Organism name while entering the Tissue specific information. I have yet to be able to figure out how to do this. I would expect that given the relation of the foreign key, I should be able to have it display the vendor/organism name from a drop down menu....again, I haven't figure this out either.
Please..please...please help me!