updating tables

[lwolff]

On our network database, accounting adds new records to an
equipment list table(when we get new equipment). I've
copied this table because I want to keep other info about
the equipment without messing up accounting's table. My
question is- How can I get my table to update
automatically when accounting adds a new record? I just
need two or three fields from their table.
Thanks.

 

[Rick Brandt]

On our network database, accounting adds new records to an
equipment list table(when we get new equipment). I've
copied this table because I want to keep other info about
the equipment without messing up accounting's table. My
question is- How can I get my table to update
automatically when accounting adds a new record? I just
need two or three fields from their table.
Thanks.

If you're talking about Jet tables (not SQL Server or equiv.) then you would have to
modify the form that Accounting uses to input their records. Jet doesn't support
triggers or any events that are driven directly from the table. It might be easier
to link to their table in your app and provide yourself with an update routine that
looks for entries in their table that are missing form yours and adds them.

 

[John Vinson]

On our network database, accounting adds new records to an
equipment list table(when we get new equipment). I've
copied this table because I want to keep other info about
the equipment without messing up accounting's table. My
question is- How can I get my table to update
automatically when accounting adds a new record? I just
need two or three fields from their table.
Thanks.

If you're storing the data redundantly, you now know why folks
discourage storing data redundantly. It doesn't update.

Why not simply link to the accounting table? You can have your own
table joined to it. It's not necessary to have all the information in
one table!