AnsweredAssumed Answered

Check if field value for a record exist

Question asked by JCPython on May 20, 2013
Latest reply on May 21, 2013 by philmodjunk


Check if field value for a record exist


     I have a couple tables that are related, each have a animal_ID field (these fields are seperate from the table unique auto serial ID)

     In one table its imported data parsed from a xml file and what i need to do is have a field of some sort next to the animal ID where it says either - not found (the animal ID in this record for this table doesnt exist in the animal_ID field in the other table) or says nothing if there is a match.

     Can someone tell me the best practices to achieve these results?


     Thanks so much! :)