1 Reply Latest reply on Feb 20, 2015 7:06 AM by philmodjunk

    Relationship trouble...



      Relationship trouble...


       I am obviously a newbie...I am building a clinical solution to reduce a convoluted flowchart into a scripted animation of Boolean responses, that when finished will guide blood bank technologists through the process of antibody identification (using Antigen-Plus).

      I have 3 tables; one table called Antibodies which uses a serial number as the primary key and contains an attribute field called "Significance" which is Boolean Yes/No. I have another table called Antibody Identification, which is the 'meat & potatoes' of the script, wherein the technologist selects the antibody(ies) from a value list created from the first table, using a Specimen ID# as the primary key. Between these tables is a join table called antibody occurance.

      Problem: I don't know how to make the attribute "significance" attach to the antibody(ies) selected FROM Antibodies but displayed IN Antibody Identification. I wrote a very long and clunky calculation that does the trick, but I know in my bones that there is a better way. How does the creation of a new record in a parent table lead to the creation of subordinate records in the join table?

        • 1. Re: Relationship trouble...

          It would appear that you have these tables and relationships:

          Antibodies-----<antibody occurrence>-----Antibody Identification

          Antibodies::__pkAntibodyID = antibody occurrence::_fkAntibodyID
          Antibody Identification::__pkSpecimenID = antibody occurrence::_fkSpecimenID

          You can place a portal to antibody occurrence on the Antibodies layout to list and select  Antibody Identification records for each given Antibodies record. Fields from Antibody Identification--such as the Significance field, can be included in the Portal to show additional info about each selected Antibody Identification record and the _fkSpecimenID field can be set up with a value list for selecting Antibody Identification records by their ID field.