Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Append Query Triggered by New Record

Append Query Triggered by New Record

Append Query Triggered by New Record

Hi, I'm working on a database for development permits. The main development permit table is linked to a table from our financial database which provides ownership and zoning information. We would like to maintain historical data for a development permit, who was the owner when the permit was issued etc. The data from the financial database is refreshed every night, it is brought into SQL from a proprietary database using a SSIS module. Is it possible on a form to trigger a query when a new record is created? That way when a new development permit is created, the corresponding record in the financial table is copied into a historical table. Is this the correct approach to this problem or should I be looking at other solutions?
Thank you,
Michael Kohler

RE: Append Query Triggered by New Record

Yes, I would like the historical table updated after the form is updated.

RE: Append Query Triggered by New Record

One may also argue the right solution is to track the owners of the property over time and instead have a query pull the owner when the permit was issued and not bother storing the owner with the permit data. This line of thinking comes from data normalization. On the other hand, there are pragmatic reasons not to do this like performance and that is a careful balancing act. Storing ownership separate does allow correcting the data in one place. If there is a backlog of ownership information being entered timely, your solution would maybe pull the wrong information if a new owner retrieves a permit near the time of purchase. Now the data has to be updated in two places if it is to be correct.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close