Update a table in all related forms and queries

[cherosoullis]

I have created a database for storing, query and deleting data. Now the user wants to delete a row from a table and create two new rows. In my opinion this will need lots of work in order to replace all related queries forms and reports in the form. Is there any whay to do my job more easy in modifing a table and all related items be modified by themself? I still do not have any data in the table but if I did will I loose those data?
Thanks.

 

[GohDiamond]

Check this recent thread to see if it relates to your question:
"Query Delete Few Tables Record "

Cheers!

Goh

 

[theprez]

It depends on how the data is set up in the tables. If you have tables that have relationships built, the tables can be automatically deleted/updated using data integrity.