Re: Designing Table for Both Global and Local Indices

2007-11-24 Thread Santino
Hi, Try to make a table for each company with only one integer field than insert a record and use the id to populate the other table. You can also delete periodically records from there companies tables. Santino At 21:48 -0500 23-11-2007, David T. Ashley wrote: Hi, I am developing a large dat

Designing Table for Both Global and Local Indices

2007-11-23 Thread David T. Ashley
Hi, I am developing a large database where the web interface may be shared among many companies, but the data will generally not be shared. For the purposes of example, let's call it a bug tracking system such as Bugzilla. Each company has their own private software bugs. Many companies may ent