Scott, how about the use of a MERGE table?
create a merge table 'orders' with 'orders_npfd' and 'orders_npfs'
underneath it.
http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html
Dan
On 8/2/06, Scott Haneda [EMAIL PROTECTED] wrote:
Forgive the mess I present you, this is a
Forgive the mess I present you, this is a strangely done site with a even
stranger structure and methodology that I am trying to work with.
The basic idea is one website has multiple websites in it. So if you place
an order with website A, orders_A is where the data is stored, if you place
an