Hi All,
i have a stupid situation I got myself into and not sure how to handle this
I have a form that creates an entry / place holder in another table.
just the reference will be held in this table
i no additional interaction is added on the form, the table remains with this reference
if additional data is entered on the form, i want to delete the initial reference
so basically, if the table has no data in the other fields except for the reference, the data must remain in the table
if additional data is entered, the line with blanks in the first record must be deleted
as below, second record must be deleted as it has related registration and sequence number with additional data
line 1 must not be deleted, it is a place holder for a different sequence number, but does not have additional data
I have created 2 queries, one that only shows records with no additional data and one that only shows records with additional data
unmached query does not seem to work for me here
i have a stupid situation I got myself into and not sure how to handle this
I have a form that creates an entry / place holder in another table.
just the reference will be held in this table
i no additional interaction is added on the form, the table remains with this reference
if additional data is entered on the form, i want to delete the initial reference
so basically, if the table has no data in the other fields except for the reference, the data must remain in the table
if additional data is entered, the line with blanks in the first record must be deleted
as below, second record must be deleted as it has related registration and sequence number with additional data
line 1 must not be deleted, it is a place holder for a different sequence number, but does not have additional data
I have created 2 queries, one that only shows records with no additional data and one that only shows records with additional data
unmached query does not seem to work for me here