On Wed, Jul 18, 2001 at 12:15:42AM -0500, Ben Luey wrote: > Maintain two tables with the two types of events. Generate the third table > that links them as needed by joining the two table by their unique id and > then making a second field "table" have a if the id is 0-10000 and "b" if > the id is 50000-60000 (or whatever the numbers are). When I want to access > both tables, I can just query all in the generated table and if table=a, > do something and if table=b do something else for each entry. Or drop the "table" field and determine table directly by looking at the ID. Why store redundant information?