How to have one field be tied to multiple fields?

I need to track how many "New Households" my company brings in on a daily
basis and what products the "New Household" buys. I built 2 tables: a
customer table that included a place where my employees would input a "1" if
a customer was a new household & a product table to enter in the products
sales & amounts.

I used these two tables as forms with the "product" table being a subform to
the "customer" table. My problem is when I pulled a query for new
households, it was marking each product a newhousehold customer opened as a
new household giving me too many new households. Ex: If I inputted Joe Smith
as a new household and he opened 4 new products, my query would say I have 4
new households when really I have 1 new household. I'm I not pulling the
query correctly or do I need to input some kind of code to recognize what I
need. I am using Access 03 & have only been using it for little more than 2
months.

Please help. Thank you.

You need to post the SQL of your queries that feed the form/suform so folks
can see what you did.
--
KARL DEWEY
Build a little - Test a little


"Norm" wrote:

I need to track how many "New Households" my company brings in on a daily
basis and what products the "New Household" buys. I built 2 tables: a
customer table that included a place where my employees would input a "1" if
a customer was a new household & a product table to enter in the products
sales & amounts.

I used these two tables as forms with the "product" table being a subform to
the "customer" table. My problem is when I pulled a query for new
households, it was marking each product a newhousehold customer opened as a
new household giving me too many new households. Ex: If I inputted Joe Smith
as a new household and he opened 4 new products, my query would say I have 4
new households when really I have 1 new household. I'm I not pulling the
query correctly or do I need to input some kind of code to recognize what I
need. I am using Access 03 & have only been using it for little more than 2
months.

Please help. Thank you.