Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Database advice

Quote Reply
Database advice
Im creating a database (using DBManSQL of course) of people (worldwide) and the languages they can speak.

I have been doing some research and the number of languages I will need to be able to handle is about 250. I will need to include their contact details (name, address, telephone, etc.) plus the languages that they speak (anything from one language to about ten languages per person). What is the best way to handle this from the following two perspectives





1/ Database table setup. Do I need 250+ columns or do I allow the user to enter multiple languages in one field? I need to be able to search the database for people who can speak the required language or languages.



2/ Input form. What would be the best way for the user to select the languages they can speak (note: some users can speak multiple languages)?? Should I use checkboxes, radio buttons or drop down menu, etc considering the number of language names I need to display?



Any advice would be most appreciated.

Thank you.

Simon.
Subject Author Views Date
Thread Database advice jai 2333 Dec 31, 2002, 1:55 AM
Thread Re: [jai] Database advice
hennagaijin 2279 Dec 31, 2002, 5:23 AM
Thread Re: [hennagaijin] Database advice
jai 2285 Jan 1, 2003, 5:46 AM
Post Re: [jai] Database advice
ManuGermany 2259 Jan 2, 2003, 6:02 AM
Post Re: [jai] Database advice
jaspercram 2267 Jan 2, 2003, 1:42 PM