Establishing Relationships with ID numbers as foreign keys

[lybargera]

Hi, I am trying to establish relationships between tables
by using the ID numbers as the foreign key. For example
using the ActivityID as a foreign in the tblBusiness to
link tblActivity and tblBusiness. Access allows me to do
this, but the Activity ID is not automatically updating in
the tblBusiness, and I can't figure it out. I have tried
cascade update. I would appreciate any advice.

 

[Lynn Trapp]

Just what do you expect should be causing it to update? Are you doing data
entry via a form/subform? What you want will not happen in the tables
without some mechanism and a form/subform is the perfect mechanism for that.

 

[John Vinson]

Hi, I am trying to establish relationships between tables
by using the ID numbers as the foreign key. For example
using the ActivityID as a foreign in the tblBusiness to
link tblActivity and tblBusiness. Access allows me to do
this, but the Activity ID is not automatically updating in
the tblBusiness, and I can't figure it out. I have tried
cascade update. I would appreciate any advice.

Relationships won't make anything automatically update, by themselves;
a relationship *restricts* what can go into the ActivityID field, it
doesn't put anything into the ActivityID field automagically.

If a business is linked to an activity, you need to specify *WHICH*
activity, say by selecting an ActivityID from a combo box on a form.