Flowing information from one table to another
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.