Prev: Relationship Help
Next: Budget Table
From: David W. Fenton on 29 Dec 2009 19:42
=?Utf-8?B?TUo=?= <MJ(a)discussions.microsoft.com> wrote in
news:AA4DFB82-5ACA-48CC-A094-21BFCCC4AB1A(a)microsoft.com:

> However, my initial
> question was since Allen categorically stated not to use lookup
> tables how can the user input data listed in another table eg
> manually? That can't be correct due to data input error.
> Any suggestions on making the form work better?

Have you read my post and John's response to you referring to it?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
From: MJ on 30 Dec 2009 01:01
Apologies on the lookup table topic. I now understand that you meant eg use
combo boxes in the form design.
Many thanks.

"John W. Vinson" wrote:

> On Tue, 29 Dec 2009 14:05:01 -0800, MJ <MJ(a)discussions.microsoft.com> wrote:
>
> >However, my initial
> >question was since Allen categorically stated not to use lookup tables how
> >can the user input data listed in another table eg manually?
>
> Neither Allen nor any of us have ever said "not to use lookup tables".
>
> What we have said is "don't use the Lookup Field datatype in Table design".
>
> Lookup tables are absolutely vital. Every database I've ever developed
> contains lookup tables.
>
> The objection is not to "lookup tables" - it's to Microsoft's misguided
> decision to include Combo Boxes ("lookup fields") in Tables. Doing so is the
> source of great confusion and bad design, and it is *not* necessary in order
> to (properly!!!) use Lookups (combo boxes, listboxes) on Forms.
> --
>
> John W. Vinson [MVP]
> .
>
First  |  Prev  | 
Pages: 1 2 3 4 5
Prev: Relationship Help
Next: Budget Table