C
cleaver
I'm still having a problem with the synchronization of the
combo boxes. The customer name will appear automatically
when I enter/select the customer ID. However, when I go
to save the new record, it comes up with the following
error message, "record is unable to be saved because a
related record is required in the Customer Information
table." The information for the form is coming from a
Systems table. The form is being used only to update the
information in the Systems table. The only information
that is consistent between the two tables is the Customer
ID. So changes on the form will not affect the Customer
Information table. Is there a way to work around this
problem because I really need the two tables to be
related???
Thanks again for all the advice given and any more
information that can be provided...
combo boxes. The customer name will appear automatically
when I enter/select the customer ID. However, when I go
to save the new record, it comes up with the following
error message, "record is unable to be saved because a
related record is required in the Customer Information
table." The information for the form is coming from a
Systems table. The form is being used only to update the
information in the Systems table. The only information
that is consistent between the two tables is the Customer
ID. So changes on the form will not affect the Customer
Information table. Is there a way to work around this
problem because I really need the two tables to be
related???
Thanks again for all the advice given and any more
information that can be provided...