Linking data fields between a main file and subfiles
What I have is a so called Main file which is linked to 3 other sub files.
All 4 of those files have the data fields nr,sulprice order nr and project name. Now what i am trying to do is when i create a new record in the main file and entered the information for nr,sulprice order nr and project name that it automatically creates that new record in the other 3 files as well,with the info for those fields...this would save me a lot of time.....sometimes the sulprice order nr. changes and i have to update it.....right now i have to update the info in all 4 files everytime.
what i am hoping for is that i only have to make the changes in the main file and all this info will than automatically go into the other 3 files as well.
there are many more fields that i am trying to link like that but as soon as someone explains me how to do it with these 3 the rest will be easy
appreciate any suggestions