questions before and nobody minded that.
I have an employee table in database A, I am using it in database A but now
I also want to use it in database B. I.e. I want to include its primary key
as a foreign key in tables that are part of database B (and the other way as
well). I am not sure how I go about that or whatever it is possible to do.
So far the only solution I can think of is to duplicate employee table
inside database B and keep it in synch with employee table inside A. For
that I don't know how to implement some MS SQL server 2000 based
synchronization (I don't really want to have to schedule/call a CF template
once a while that does the synchronization). I hope I am making some sense
her, I am much better with CF than SQL. Thanks for any help,
Best Wishes,
Tom Kitta
Advanced ColdFusion Programmer
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]