duplicate tables

D

d_renny

I would like to have a products table (table2) which is identical to another
products table (table1) contained within a customer orders database. The
idea is to only enter data into the customer order db so that when the
products table (table1) is changed the second external products table
(table2) is dynamically updated. Table 2 provides a data source for a CF web
application. What is the best way to accomplish this?
Thanks
 
J

John Vinson

I would like to have a products table (table2) which is identical to another
products table (table1) contained within a customer orders database. The
idea is to only enter data into the customer order db so that when the
products table (table1) is changed the second external products table
(table2) is dynamically updated. Table 2 provides a data source for a CF web
application. What is the best way to accomplish this?
Thanks
Click to expand...

Why on Earth would you WANT to maintain two whole tables redundantly?

Just base your CF Web application on the products table, or on a query
based on the products table. Keeping two updateable tables in synch
would be just barely possible, but a lot of extra work for no benefit
which I can discern. Am I missing something about CF?

John W. Vinson[MVP]
 
D

d_renny

I see your point. The CF Web app is currently using the products table of
the main database as a datasource. I have a limited amount of space on my
web server and was wishing to reduce file size by only needing the products
table stored remotely as the datasource.
 
J

John Vinson

I see your point. The CF Web app is currently using the products table of
the main database as a datasource. I have a limited amount of space on my
web server and was wishing to reduce file size by only needing the products
table stored remotely as the datasource.
Click to expand...

Well, the tradeoff would be to use some appropriate event - a Form's
AfterUpdate event comes to mind - to delete the external file being
used by CF Web (taking down your website in the process of course) and
recreate it by exporting from the local table; or opening it as an
exclusive Recordset (likewise blocking your website) and running an
Update query to synch it with the local table.

John W. Vinson[MVP]
 
D

d_renny

Ya, that tradeoff is basically the same as my current process of just
overwriting the database with an updated copy using FTP whenever there is a
products change. Maybe I should just accept the file size and work off of
the remote file only.
Thanks for your time John!
 
Top