change field properties, reflect in query

From: SueP (SueP_at_discussions.microsoft.com)
Date: 11/09/04 

Date: Mon, 8 Nov 2004 17:17:02 -0800

I am a new Access user--don't use code, just the wizards & design views.
I have two main tables with a 1-to-1 relationship (couldn't fit all the
fields in one table--property value too large), and several lookup tables. I
created multitable forms using a query that contains both main tables. All
was working well until I had to change/add some of the lookup tables and
establish some new relationships between some fields in the main two tables
and the lookup tables. The query is no longer recognizing the formatting for
the field types (yes/no check box, lookup combo box, etc) or the default
values for the fields in one of the main tables. I have checked the
relationships. I have tried re-creating the query, but to no avail. Any
suggestions? p.s. It's in Access 2002.

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: How Do I make fields not appear on a form or report
    ... Open the Query in design view. ... the text field from the lookup table to include in your report. ... The Access Web resources page: ...
    (microsoft.public.access.forms)
  • 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: Basic Question for Lookups.
    ... However, especially in the early phases of setting up your Tables, you will probably need at times to look at their contents, and if so, you probably will want to define lookup properties on the foreign keys. ... The Query that I would suggest is similar to what the Lookup Wizard defines, except that I give mine a name, and I limit it to 2 fields instead of several. ... 1801550689 Michael Zachary Jackson ... I'm properly storing Prospect ID pk then FirstName then Middle then Lastname fields.etc. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Tip: Table design and query for bracketed lookup
    ... WHERE [Enter Bracket:] ... No rows would be returned by the query! ... If the "lookup" value is in a column of your query called Lookup, ... FROM RateTable RT1 ...
    (microsoft.public.access.queries)