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
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
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
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