Query Won't Let You Add Records
From: Harrison, Larry [LarryH@APPLIEDIMAGE.com]
Sent:
Tuesday, January 30, 2001 1:52 PM
To:
'larrytucaz@mindspring.com'
Subject: microsoft access help, query
won't allow you to add records
Never mind. I have found the fix. In case any of
you out there have the same problem, here is the solution:
The ID field from the DD Box table (under
table...design view) was indexed, but it was allowing duplicates, and it
shouldn't have been. When I changed this, the problem was fixed.
In article <957703$lsr$1@nnrp1.deja.com>,
Larry H <larryh@appliedimage.com>
wrote:
> I have a query which joins two tables together. One table, FRONT
END,
> is the dominant one. It has a field called PROJECT MANAGER which is
a
> numberic field and it matches up with the ID field in the other
table,
> DD BOX. The relationship is defined in the query but not in
the
> relationships window. It is NOT a 1-to-many. Under join type,
the
> option selected states "Show all records from FRONT END and only
those
> from DD BOX whose values is equal..." etc.
>
> In
this query, the Project Manager field from the DD BOX table is the
> only
field from that table shown, all the other fields come from the
> FRONT
END table. What this does is it shows the name of the project
> manager
associated with the numeric field stored in the PROJECT MANAGER
> field of
the FRONT END table (the main one).
>
> This query will not allow
me to add any records to it. This puzzles me,
> because I have another
query set up EXACTLY the same way (though with
> different fields from
other tables) and it allows me to add records all
> day to it. I tried
defining this same relationship in the relationship
> window. Still not
fixed.
>
> What is the fix for this?
>
> Larry R
Harrison Jr
>
> Sent via Deja.com
> http://www.deja.com/
>
Larry R Harrison Jr