AnsweredAssumed Answered

Foreign key confusion

Question asked by akh on Nov 11, 2008
Latest reply on Nov 13, 2008 by TSGal


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!