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?
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.