S
SPRLowe
I have a table containing client records. I have been
adding records to this as I change and develop my
database. I have a form using the table as its data
source.
I also have a select query based on this table and another
form using that query as its data-source. When this query
selects older records, there is no problem and they can be
edited in the form, as well as directly in the query.
However, when I select some recently created records, they
cannot be edited and are shown as locked, when I view them
in the query.
Other than I know some records have been created more
recently, there is no discernable difference between these
records –so why can some be edited and others not?
There is a further complication. The query selects
records that are linked to other records in the table.
More than one record can be linked as an “associate”
record of a “master” client record. To do this, the
unique identifier in the autonumber field of the master
record appears in a field in the associate record. The
query effectively shows me all associates of the master
record. If the master record is an older record, and I
create a new associate record, then I will be able to edit
the associate record in the query and the form based on
it. However, if I create a new associate to a newly
created master record, then the new associates record
cannot be edited!
There seems no reason at all why all associate records
cannot be edited equally.
Any ideas, please?
adding records to this as I change and develop my
database. I have a form using the table as its data
source.
I also have a select query based on this table and another
form using that query as its data-source. When this query
selects older records, there is no problem and they can be
edited in the form, as well as directly in the query.
However, when I select some recently created records, they
cannot be edited and are shown as locked, when I view them
in the query.
Other than I know some records have been created more
recently, there is no discernable difference between these
records –so why can some be edited and others not?
There is a further complication. The query selects
records that are linked to other records in the table.
More than one record can be linked as an “associate”
record of a “master” client record. To do this, the
unique identifier in the autonumber field of the master
record appears in a field in the associate record. The
query effectively shows me all associates of the master
record. If the master record is an older record, and I
create a new associate record, then I will be able to edit
the associate record in the query and the form based on
it. However, if I create a new associate to a newly
created master record, then the new associates record
cannot be edited!
There seems no reason at all why all associate records
cannot be edited equally.
Any ideas, please?