Search results

Pat, Thank you for your reply. I forgot to mention in previous posts, that I am trying to do this in ADO. You supplied me with the method of doing what I wanted to do any way. I got the following two subs to work for me: To establish a relationship: Private Sub cmdAddRelshp_Click()...

Bayman, I looked in the help files under Alter Table Statement. It covers adding a field to a table, changing an existing field's data type, adding a foreign key field, and removing a foreign key field. What table property or method must be altered to add or remove referential integrity, add...

Bayman, Thank you for your reply. I think your reply is a little over my head. How do I setup the "Run SQL with an ALTER TABLE statement"? The tables in question are tblSecurities, tblYears, tblJan1NAVs, tblCapGains, tblDividends, and tblDec31NAVs. There is an hierarchy relationship between...

Is it possible to programmatically, using VBA, to change referential integrity between tables in the same database? Is it possible to programmatically, using VBA, to add and remove Cascade Update Related Fields or Cascade Delete Related Records in the relation ship between tables in the same...

Pat, That is exactly what I have. There is no relationship between tables tblJan1NAV, tblCapGains, tblDividends, and tblDec31NAV. Each of these tables has a hierarchical relationship with tblYears, but not with each other. Thank you. Ed

Thank you for your quick response. I am new with Access and had never come across a Read-Only select query. I only removed the referential integrity to see if that would change the query so it wasn't read-only.

I have a select query that is based on six tables. The table relationship is as follows: tblSecurities one to many to tblYears, tblYears has a one to many to tblJan1NAV, tblCapGains, tblDividends, and tblDec31NAV. I have removed referential integrity between all of these tables in the...