Automatic Rows Insertion

[Participant]

Hi guys,
I have a small question regarding automatic insertion. I want a way using
which I can automatically insert a number of rows in TableB whenever I enter
a row in TableA.

Any ideas?

 

[a a r o n . k e m p f]

it's called a trigger.

SQL Server supports it.
Access does not.

-Aaron

 

[KARL DEWEY]

Are you talking about Parent/Child tables? Set a one-to-many relation with
referential entegrity and cascade update.

 

[a a r o n . k e m p f]

re:
automatic insertion

for example-- he might have a one to one relationship where he wants
the primary table to automatically populate the 2nd table.

for example; northwind database-- if they have Orders and another
table called OrdersPrivateInfo... Where OrdersPrivateInfo might
include the '_______-size' (insert some body part).

If it would be a common requirement to keep this '______-size'
seperate from all the other info-- it might make sense to have a one
to one relationship.
Whenever a new order was made-- the OP wants ot have a record
automatically inserted into the OrdersPrivateInfo'.

Access doesn't have this functionality-- SQL Server does. It's called
a trigger.
Time to stop making excuses-- and move to SQL Server, kids.

-Aaron