Form built on Query

[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?

 

[Dirk Goldgar]

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?

It sounds like your [Quote Header] query may join the QuoteDetails table
with the QuoteHeader table, when it probably shouldn't. Post the SQL of
the queries, and we can probably see what's wrong.

 

[Guest]

Thanks Dirk. I changed the main form to be based on the QuoteHeader Table
and this seems to have solved it.

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?

It sounds like your [Quote Header] query may join the QuoteDetails table
with the QuoteHeader table, when it probably shouldn't. Post the SQL of
the queries, and we can probably see what's wrong.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)