Re: Database terminology

the
word "lookup" has such a negative connotation for me...

"and thou shalt abhor the use of "Lookup Fields" which art the creation
of the Evil One."

-/http://www.mvps.org/access/tencommandments.htm/

I know... fields and tables are different, but still, it weighs so
heavily upon me...

LOL

i usually call them "supporting" tables, myself - i don't like the Lookup
association, either - because they support the "real" data tables. :)


"Smartin" <smartin108@xxxxxxxxx> wrote in message
news:au-dnWC3GNisEMfYnZ2dnUVZ_rqdnZ2d@xxxxxxxxxxxxxxx
Cyberwolf wrote:
That does make more sense. Since I am a self taught DB admin, I have
just
come up with my own terminology and then chage it as I hear from the
experts.

I rather prefer "static tables" myself, but perhaps this is because the
word "lookup" has such a negative connotation for me...

"and thou shalt abhor the use of "Lookup Fields" which art the creation
of the Evil One."

-/http://www.mvps.org/access/tencommandments.htm/

I know... fields and tables are different, but still, it weighs so
heavily upon me...

--
Smartin


.

Relevant Pages

  • Re: Storing Foreign Key in a table
    ... for now to agree that lookup fields are to be avoided. ... I can't make out what you mean by storing "the text of the foreign key to ... My combo boxes load but do not display a value. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Problem with Subform not displaying correct data
    ... your problem was that you were displaying the wrong column. ... can do that with both List boxes and Combo boxes. ... against using lookup fields ... >> that the problem is caused by the Lookup fields in the tables. ...
    (microsoft.public.access.forms)
  • Re: An unknown error has occured...
    ... Do you have lookup fields defined? ... when you run out of the IDE with debug set to stop on errors. ... (Project raised exception class EOleException with message "Ett okänt ...
    (borland.public.delphi.database.ado)
  • Re: Help-How to select multiple values using lookup function???
    ... the lookup fields in Project are not multi-select fields. ... may be possible through enterprise fields using Project Server, ... With the lookup function, it will only allow 1 selection. ...
    (microsoft.public.project)
  • Re: Receive a 3134 error
    ... How do I remove the lookup column? ... Dealing with the lookup fields is a separate issue. ... necessarily what it is displaying. ...
    (microsoft.public.access.modulesdaovba)