Gossamer Forum
Home : Products : DBMan SQL : Discussion :

200 + Fields

Quote Reply
200 + Fields
Hi,
I'm setting up a database which needs a text field for almost every country in the world. This means 200 + text fields.
Can anyone give me some advice on how to handle this type of situation? Should I break the tables down to say 25 countries per table and have the form submit to multiple tables?
What should I do?
Thank you.
Simon.

Quote Reply
Re: 200 + Fields In reply to
Intersection tables...JOIN them...

Regards,

Eliot Lee
Quote Reply
Re: 200 + Fields In reply to
Eliot,
Thanks for your reply but like many people in these forums I need a little more help.
Where can I find out how to set up the Intersection Tables and how many fields should I have in each table?
A little more advise would be most welcomed.
Also, I tried to set up a form with 4 list menus with all the 200 + countries but it crashes my browser. Any ideas on how to deal with that situation as well would be welcomed.
Thank you.
Simon.

Quote Reply
Re: 200 + Fields In reply to
Jai,
I think you need to do some reading on relational database design.
Do a search in Google for database design, normalization or normal form, you will find heaps of info that will put you on the right track.

Bob
http://totallyfreeads.com


Quote Reply
Re: 200 + Fields In reply to
Yea...do some research on RELATIONAL database design...this will help you to effectively design your tables/databases...

Regards,

Eliot Lee