Re: Database terminology

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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)