A
Alex
I have a query 'AllParts' containing 1 table 'AllPartstbl' and 4 queries.
The 4 queries' data sources are tables which I do not want updated. I've set
the 4 queries' Record Locks to All Records. I have left joins in the
'AllParts' query to show all records from my table and only those matching
records in the 4 queries.
I use this 'AllParts' query as the data source for my form and I only want
'AllPartstbl' updated when I add or delete a record, not the tables the 4
queries are based on. When I create a new record in my form I'm getting an
error message/ "Index or primary key cannot contain a null value" when the
primary key fields (there's 3 in my table) are not null. The only reason I
can think of that I'm getting this error messag is that it's also trying to
update one of the tables my 4 queries are based on. I only want to update
the 'AllParttbl' using the form, not the tables from the 4 queries. Is it
possible that I have the relationships in the form set up incorrectly? I
tried setting up relationships in the relationship window so that I could set
referential integrity, but I kept getting an error, "no unique index found
for the referenced field of the primary table." My primary table has a 3
field primary key. Thanks so much for your help.
The 4 queries' data sources are tables which I do not want updated. I've set
the 4 queries' Record Locks to All Records. I have left joins in the
'AllParts' query to show all records from my table and only those matching
records in the 4 queries.
I use this 'AllParts' query as the data source for my form and I only want
'AllPartstbl' updated when I add or delete a record, not the tables the 4
queries are based on. When I create a new record in my form I'm getting an
error message/ "Index or primary key cannot contain a null value" when the
primary key fields (there's 3 in my table) are not null. The only reason I
can think of that I'm getting this error messag is that it's also trying to
update one of the tables my 4 queries are based on. I only want to update
the 'AllParttbl' using the form, not the tables from the 4 queries. Is it
possible that I have the relationships in the form set up incorrectly? I
tried setting up relationships in the relationship window so that I could set
referential integrity, but I kept getting an error, "no unique index found
for the referenced field of the primary table." My primary table has a 3
field primary key. Thanks so much for your help.