RE: change field properties, reflect in query

From: Bruce (Bruce_at_discussions.microsoft.com)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 05:08:02 -0800

If you used two tables because you could not fit all of the fields into one
table, it is likely you are doing something wrong with your database design.
A general rule for table design is that you should be able to describe the
tables function in a single sentence without using the word "and" (unless for
name and address or something like that). If you are keeping track of
customers and orders, or students and courses in one table, it's time to step
back for another look. A one-to-one relationship is very specialized, and I
wonder if that is what you need.
It would help if you could describe what you need to do with the database,
what you are looking up with the lookup lists, and so forth. I expect the
folks in this group can help you set up a clean, smooth-running database, but
will need some details in order to offer specific guidance. Much of what I
have learned about Access I learned right here, but there is definitely a
learning curve. I wish I had asked a few more questions before undertaking
some of my earliest projects, but I didn't know about this group then.

"SueP" wrote:

> 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: Join to one of two tables (based on a value in the source table)
    ... > yourself a query that returns apples or octopi. ... or the database in which it resides). ... for items not found in that lookup ... is set to 1, joining tableLists.UnitName to tblLists_lookup2.UNITNM. ...
    (microsoft.public.sqlserver.programming)
  • Re: Join to one of two tables (based on a value in the source table)
    ... >> yourself a query that returns apples or octopi. ... > or the database in which it resides). ... > table to store similar information, for items not found in that lookup ... I need data from a table that doesn't belong to me ...
    (microsoft.public.sqlserver.programming)
  • Re: Row cannot be located for updating error (ADO)
    ... "DBEdit1 the field double clicked) in the OnDoubleClick event is writing ... directly to the database but the data aware controls are writing to the ... >>lookup value) dependant on the users selection this is then saved to the ... > I assume your query is a Join using fields that come from the table your ...
    (borland.public.delphi.database.ado)
  • RE: Subform button characteristics
    ... The query filters the data down to a small list, ... This isn't good database design. ... created a button on the subform that goes with each record. ...
    (microsoft.public.access.forms)
  • Re: transaction disabling
    ... All this is internal to the database. ... couple of fields to the new/changed lookup key values. ... I am doing this as I have a dynamic query building form that users ... The filter keys are higher in the ...
    (microsoft.public.sqlserver.server)