4 Replies Latest reply on Jul 15, 2013 7:05 AM by philmodjunk

    Flowing information from one table to another

    RobertRichmond

      Title

      Flowing information from one table to another

      Post

           Hello all,

            

           When I have information entered into one table, how do I get it to automatically flow into a related table?

           e.g. I have a table called Work Variations. When a staff member fills in the record, I want some of the records to also flow into the related table - "All Homework support with Work Variations" , using related fields. 

           The reason I have done it this way is that sometimes the staff member enters in homework support info (which has different fields as well as some of the same fields) and they may also enter in a work variation (which also has  different fields as well as some of the same fields) . The same fields are then being collected together in one table which I can work with. 

           I also want the data to be deleted should it be removed from the primary table.  I have attached an image of my present layout in case this might assist.

      Screen_Shot_2013-07-15_at_1.27.44_PM.png