Establishing Relationships with ID numbers as foreign keys

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.

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.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"lybargera" wrote in message
...
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.

On Wed, 16 Jun 2004 09:48:08 -0700, "lybargera"
wrote:

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public