Re: Can I use replace function on a string to create form drop bo x options?

On 10/21/06, Andrew Tyrone [EMAIL PROTECTED] wrote: Just put the days in the list, not codes ;-)) That will make a field with a max of what? 50 characters may be? Big deal! ;-) And...? It doesn't matter which types of data you store in those lists. How would you return a workable query?

Re: Can I use replace function on a string to create form drop bo x options?

What if a manager would like a printout of the days of the week and which employees are available to work on each of those days. If I worked for a company and had a manager liable to ask anything after a project has been designed, then of course, I would take a belt and suspenders and use a

RE: Can I use replace function on a string to create form drop bo x options?

1º using a (small) list is not a workaround, it is a short cut. Before I take short cuts, the first thing that comes to mind is, I hope I won't need to redo this later. 2º updating one field in a table is much more straightforward than updating a multi records cross table. If you mean the

RE: Can I use replace function on a string to create form drop bo x options?

1º using a (small) list is not a workaround, it is a short cut. Whatever you want to call it, doesn't matter to me. I find that, for me, taking short cuts now often means longer detours later. 2º updating one field in a table is much more straightforward than updating a multi records cross

Re: Can I use replace function on a string to create form drop bo x options?

Before I take short cuts, the first thing that comes to mind is, I hope I won't need to redo this later. Then if you're not sure, don't do it. The purpose of and RDBMS is storing data in a relational way in the first place, Right, when there is a relation worth to be treated as such. so

Re: Can I use replace function on a string to create form drop bo x options?

In this specific case, you have a fixed list of Boolean values. I said a short list, it doesn't have to be fixed. It can be a list of codes related to a table with codes and description, and this table is expandable. But you don't always need a cross table between them. I use this for

RE: Can I use replace function on a string to create form drop bo x options?

Just put the days in the list, not codes ;-)) That will make a field with a max of what? 50 characters may be? Big deal! ;-) And...? It doesn't matter which types of data you store in those lists. How would you return a workable query? You can't, and you'd have to jump through a bunch of

RE: Can I use replace function on a string to create form drop bo x options?

I'd actually rather brush my teeth with a chainsaw than store a delimited list in a database field You see? This is unbelievable what kind of weirdness people can do when they go by the book ;-) I've got to agree with Andrew here. Why bother implementing a bunch of workarounds, etc,

Re: Can I use replace function on a string to create form drop bo x options?

Why bother implementing a bunch of workarounds, etc, when you can just build a table and the appropriate relationship? C'mon, we've discussed this many times, 1º using a (small) list is not a workaround, it is a short cut. 2º updating one field in a table is much more straightforward than