You're right, Rudy. The application is for the insurance industry. The table creation was because we are giving the ability to set up customizable plans of varying input, so we never know the fields that need to be available.
However, we have since re-thought the issue because of the point you bring up. The info would be very helpful if brought together for statistical analysis, so we have re-designed it so that defined tables can be used to store the info. steve > >> ... based on the way were planning to design it. > > thanks, mark, for looking that up, i was too busy ;o) > > steve, how are you designing it so that you're worried about the number of > tables? > > just curious, but i've seen people do this by creating a new table for each > user, or a new table for each vendor, or something... and then they get > stuck when they want to write a query to pull data from all those tables... > > > rudy ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
