hi! there access expert!!
i'm struggling with update tables ..
in detail i've got more than 800 tables. each table has 21 common fileds
and have different property fileds..(it's industry materials database)
i made up the integrated table with each common fileds.
i also made up the form to search & update integrated table.
then now i've trouble to update the individual table from the integrated table (called master table & this database has one to one relation ship)
i mean that when i update master table using the form ...
i also want to update related individual table..
thanks to you in advance and wish you happy new year!!
Are you trying to populate a table with data from a lookup table using a form?
Are you trying to link a main form to a subform with a 1to1 relationship?
Are you trying to create a matching record (same ID) in a child relation when you add data in the sub-form?
If you have a master table with an autonumber primary key (ID)
Create a child table with a long integer foreign key
Create a form based on the master table, then add a subform based on the child table. When you use a wizard, the application will prompt you for the fields to link. You can also manually establish or change this link in the properties of the subform.
Now if you want the child records to be deleted when you delete the matching master records (to avoid ending up with orphan records), you can set up a delete cascading relationship in the relationship feature of your application (under the tools menu). add your two tables, connect the two linked fields, right-click the link and establish the cascading relationship. Note that this can only be done when records are currently matching (or tables are empty). See your help file on more detailed info.
This feature will also delete child records when you delete master records from the table, without using the form.