Re: How Do I make fields not appear on a form or report

On 18 Apr 2007 11:01:37 -0700, Lisa <dlhenne@xxxxxxxxxxx> wrote:

Okay here it is. The problem is the fields such as "eatltg2",
"swgl1", "swgl2", are all based off of table that is autonumber and
text. I am storing the auto number in the table to save space

Open the Query in design view. Add the three (?) lookup tables to the query
grid, joining the Primary Key to the numeric foreign key in your table. Select
the text field from the lookup table to include in your report.

Based on the SQL, you have a LOT of repeating fields and improper
normalization! You may want to read up on normalization; there are some good
links in the "Database Design 101" links on Jeff's webpage:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Lookup Evils
    ... a query window and join them by the Measurement unit field (ie not the ID ... It is indeed good design to create a relationship. ... You can add a 'lookup' table more than once to the relationship window ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Using Lookup fields
    ... Use of the lookup wizard feature at the TABLE DESIGN level ... lookup feature at the TABLE design level is the thing to avoid. ... You are even ok to use the lookup wizard when you build a query (often, ... just try and build a simple report based on that table with a lookup ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Query returns incorrect column...
    ... Your query is behaving pretty much the way we normally design our databases. ... 2nd column instead of the autonumber. ... Alternatives might be to include the lookup table in your query. ...
    (microsoft.public.access.queries)
  • Re: why cant i edit my form?
    ... form design abit. ... state table is just for a lookup and i do have a combobox ... on my form for it (if the user wants to edit it).. ... >for Users and a subform for the rest of the query. ...
    (microsoft.public.access.forms)
  • RE: Multiply qty of filtered records
    ... If you should want to try doing this with a query (which is probably the more ... etc in the bottom part of the design view. ... I do know how to get this information in a Report, ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
Loading