Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Database Field Advice

Quote Reply
Database Field Advice
Hi,

I'm setting up a table of public (national) holidays in different countries. I guess each country will have between 10 and 25 dates to be entered. If my limited knowledge of good database planning is correct, it's not good practice to enter something like (mm/dd) - 01/15,02/25,03/04,04/21,05/23,06/18,07/03,08/30,etc. into one field. I think each date should be entered seperatly but that means the user will have to enter 10 to 25 records which I don't want.

Any suggestions on how to handle this kind of problem?

Thank you.

Simon.
Subject Author Views Date
Thread Database Field Advice jai 5342 Jan 21, 2003, 3:33 AM
Post Re: [jai] Database Field Advice
jaspercram 5156 Jan 21, 2003, 7:27 AM
Thread Re: [jai] Database Field Advice
Paul 5164 Jan 21, 2003, 8:44 AM
Thread Re: [Paul] Database Field Advice
jai 5140 Jan 24, 2003, 4:09 PM
Thread Re: [jai] Database Field Advice
Paul 5140 Jan 24, 2003, 4:14 PM
Thread Re: [Paul] Database Field Advice
jai 5139 Jan 24, 2003, 5:35 PM
Thread Re: [jai] Database Field Advice
Paul 5152 Jan 24, 2003, 5:46 PM
Post Re: [Paul] Database Field Advice
jai 5099 Jan 26, 2003, 11:15 PM
Post Re: [Paul] Database Field Advice
jai 5089 Jan 28, 2003, 8:59 PM