Forms with Subforms

I have a main correspondence form. There is a relationship between the
correspondence and the location (asset number), as correspondence is always
about a location. Sometimes the correspondence will relate to work currently
being done at a particular location.

So my fields for the main form drawn from the underlying tables of locations
and correspondence a correspondence id, Asset Number , type of enquiry,
stage of enquiry, description (join on Asset number). Now due to popular
request, I am also attempting to include a sub form which populates whenever
the correspondence is in relation to a location where work is currently
taking place. This is drawn from records in the current job table, ( fields
there are job id, asset number (fk), current treatment, planned upgrade,
planned completion date, so there is also a join there on asset number.)
What is happening is that since adding the subform, every time I try adding
correspondence, I get a message telling me that it needs to update the
current job table as well. I have tried changing the relationships, but
despite manipulation of anything that will move, cannot get a situation as I
had hoped that the subform is there for information only. Any suggestions
please?

will give my input since no one else has answered....though I am no MVP...

it seems like you have the correct parent/child relationship between the two
tables on the key field asset number...

and presuming you used the subform wizard to inset the current job table
then I believe your question boils down to; "a message telling me that it
needs to update the current job table "

I say this because if I understand you - when you select a record on the
main parent form it is displaying the correct child form record....and the
problem occurs when you attempt to close/leave the record...

my first thing would be to check whether your parent form is set to property
'Add Data'...Yes; because that would force it to be looking for a new record
to be added..
--
NTC


"suek" wrote:

I have a main correspondence form. There is a relationship between the
correspondence and the location (asset number), as correspondence is always
about a location. Sometimes the correspondence will relate to work currently
being done at a particular location.

So my fields for the main form drawn from the underlying tables of locations
and correspondence a correspondence id, Asset Number , type of enquiry,
stage of enquiry, description (join on Asset number). Now due to popular
request, I am also attempting to include a sub form which populates whenever
the correspondence is in relation to a location where work is currently
taking place. This is drawn from records in the current job table, ( fields
there are job id, asset number (fk), current treatment, planned upgrade,
planned completion date, so there is also a join there on asset number.)
What is happening is that since adding the subform, every time I try adding
correspondence, I get a message telling me that it needs to update the
current job table as well. I have tried changing the relationships, but
despite manipulation of anything that will move, cannot get a situation as I
had hoped that the subform is there for information only. Any suggestions
please?