G
Guest
I have a form called Quotation based on a Query called Quote Header and a
sub-form called QuoteDetails based on a Query called QuoteDetails.
My problem is this: If I enter more than one line into my subform, the main
form becomes multiple records with the same Quote #. I am using a field
called Quote# as an Auto number. So, if I enter two records in the subform
field, I end up with two records using the same Quote # in the main form.
As I look at my old data base, I see that in queries and tables this is
done. However, in the form it was consolidated into one record. Any
suggestions?
sub-form called QuoteDetails based on a Query called QuoteDetails.
My problem is this: If I enter more than one line into my subform, the main
form becomes multiple records with the same Quote #. I am using a field
called Quote# as an Auto number. So, if I enter two records in the subform
field, I end up with two records using the same Quote # in the main form.
As I look at my old data base, I see that in queries and tables this is
done. However, in the form it was consolidated into one record. Any
suggestions?