Referential Integrity Problems

  • Thread starter Thread starter georgeg via AccessMonster.com
  • Start date Start date
G

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
 
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
 
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
Click to expand...
[quoted text clipped - 12 lines]
George
Click to expand...
Click to expand...
 
Back
Top