Re: Subject Headings in Tables

2004-11-10 Thread SGreen
With all possible respect, what you posted aren't tables, those are lists. At a minimum, tables have names and one or more fields; each field will have a data type. Please post your table structure(s) and we can suggest methods you can use to generate the output you desire. Shawn Green Databa

Re: Subject Headings in Tables

2004-11-09 Thread David Blomstrom
Oops, I forgot my follow up question... I now have two tables: TABLE 1 Alabama Alaska Arizona Arkansas California Colorado Connecticut TABLE 2 Far North New England Pacific Coast South Southwest Rocky Mountains If I had put all of the above in one table, then it would be easy to display them

Re: Subject Headings in Tables

2004-11-09 Thread David Blomstrom
OK; thanks! --- [EMAIL PROTECTED] wrote: > Normalize, David. Normalize. Your Regions get their > own table. If a > country/state can belong to more than one region you > will need another > table to hold that association. > > I can't remember if this was ever recommended to > you but I had a

Re: Subject Headings in Tables

2004-11-09 Thread SGreen
Normalize, David. Normalize. Your Regions get their own table. If a country/state can belong to more than one region you will need another table to hold that association. I can't remember if this was ever recommended to you but I had a chance to re-read it recently and think this could help