Adding/modifying records via a Query with a One to Many Relationsh

[Guest]

I have two tables set up - one is Header info and the other is detail - this
is used in a form /subform relation - what I want to be able to do is if
there is an error with entry to go into a query - search for the record and
be able to add additional items to it or modifiy any information if
necessary.

an example would be like an invoice - it was generated however something was
left out in the subform area and you would need to add it later.

Thanks for any insight.

 

[Smartin]

I have two tables set up - one is Header info and the other is detail - this
is used in a form /subform relation - what I want to be able to do is if
there is an error with entry to go into a query - search for the record and
be able to add additional items to it or modifiy any information if
necessary.

an example would be like an invoice - it was generated however something was
left out in the subform area and you would need to add it later.

Thanks for any insight.

There are basically two ways to approach this, which you can intermingle
to suit your needs.

The "hard-core" way is to make all required fields mandatory in the
table definition. An offshoot of this is to constrain certain fields to
allow certain values by creating relationships to other tables that
define what values are permitted.

This method will prevent incomplete records from being created in the
first place, eliminating the need to search them out later. However,
this may not be practical from the user's perspective. There are
situations where required information is not always available at the
outset, but it is better to get the preliminary info into the database
and follow up later.

The "follow up" approach entails writing queries to look for incomplete
records to the extent that you have allowed them.