AnsweredAssumed Answered

Only add non existing records

Question asked by Kaps_1 on Jul 31, 2013
Latest reply on Jul 31, 2013 by Kaps_1


Only add non existing records


     I am trying to add records into a table called "Chapter Top Professions".  A record consists of three fields:-

     * chapter id

     * profession

     * yes no

     However, I only want to add the record if it does not exist already. The two fields chapter id and profession come from related tables chapter and categories. There are relationships between the tables :-

     Categories:category = Chapter top profession: category

     chapter:chapter id = chapter top profession:chapter id

     but it seems to stall. Any ideas ? I attach my code sample.thanks