adding records to linked tables

[Guest]

Dear Friends,
I have seven tables(various details) linked to one table
(name)I created a query and form. But couldn`t add records
to linked tables.
Thank You

 

[Marin Kostov]

If you have created relationships, you need to force Referential Integrity.
Open the Relationships window, double-click the line between the tables, and
check Enforce Referential Integrity. You may also check and Cascade Update
and Cascade Delete.
Press F1 and in the Answer Wizard type About relationships in an Access
database.

 

[dandgard]

You must make sure that the query you created is updateable. Often whe
creating links between tables abiguities arise and access cannot tel
what record in which table to update, at that point it just doesn'
allow any updates or additions.

If the query will allow updates then the form with the query as a dat
source should allow updates.

If the query allows updates check the form to make sure the form allow
additions

 

[dandgard]

You must make sure that the query you created is updateable. Often whe
creating links between tables abiguities arise and access cannot tel
what record in which table to update, at that point it just doesn'
allow any updates or additions.

If the query will allow updates then the form with the query as a dat
source should allow updates.

If the query allows updates check the form to make sure the form allow
additions

 

[dandgard]

Also additions can be problematic, if you have a linked table in a on
to many relationship and you must have an entry in the One to be abl
to create a record in the many - you may run into problems.

You probably want to change your form to relate to the main table onl
and use subforms to tie the linked tables to it. In this fashion yo
can update the underlying tables in the subforms (access will allow yo
to link tables between form and subform) and be sure they meet th
relationship requirements

 

[dandgard]

Also additions can be problematic, if you have a linked table in a on
to many relationship and you must have an entry in the One to be abl
to create a record in the many - you may run into problems.

You probably want to change your form to relate to the main table onl
and use subforms to tie the linked tables to it. In this fashion yo
can update the underlying tables in the subforms (access will allow yo
to link tables between form and subform) and be sure they meet th
relationship requirements

 

[John Vinson]

Dear Friends,
I have seven tables(various details) linked to one table
(name)I created a query and form. But couldn`t add records
to linked tables.
Thank You

Well? How are you trying to add them?

Normally you would use seven Subforms, one for each linked table, on a
Form based on the Name table.