Referential Integrity Problems

[georgeg via AccessMonster.com]

I have created a database (using access 97), it has 14 tables. Equip table
has one auto field called "number", the rest of the tables use this field
(number) as their key to keep all information related to a record in "equip"
table.

Eight of the 13 tables work fine, the referential integrity synchronizes,
when I change records in "equip" table, the information changes acording to
the record in "equip" table. My Problem, five tables do not keep referential
integrity. They have the same basic structure, their referential integrity
is defined the same way as the eight that are working, yet the "number" field
that should auto populate (in the five tables) as a result of the referential
integrity does not show up.

Any suggestions, and or ideas? Thanks.

George

 

[Guest]

This is not an RI issue, rather a problem with linking a subform to a
mainform. Click on the subform control in Design View to select it, then open
the property sheet and choose the linking field in LinkMaster/LinkChild on
the data tab.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[georgeg via AccessMonster.com]

It Works, THANKS for the help.

George

This is not an RI issue, rather a problem with linking a subform to a
mainform. Click on the subform control in Design View to select it, then open
the property sheet and choose the linking field in LinkMaster/LinkChild on
the data tab.

I have created a database (using access 97), it has 14 tables. Equip table
has one auto field called "number", the rest of the tables use this field

[quoted text clipped - 12 lines]

George