Tracking purchasing customers (1 Viewer)

browninaz

Ugly Data Hoarder
Local time
Today, 08:49
Joined
Oct 26, 2012
Messages
88
Hello all,

I want to track purchasing customers. I have created two tables, tblcustomer, and tblcustomerinvoice. I have created a yes/no field for purchased in tblcustomer, and placed that field in frmcustomerinvoice and set the properties to =1 so that it shows that the customer purchased when a new invoice is created. The problem I am having is that if the customer is a repeat customer, the yes/no field in tblcustomer already =1 and does not show when I run my query.

Thanks to all who know more than me...
 

browninaz

Ugly Data Hoarder
Local time
Today, 08:49
Joined
Oct 26, 2012
Messages
88
Thanks for the quick response. No, I hadn't looked there yet, but I will.

I'll be back...
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 02:49
Joined
Jan 20, 2009
Messages
12,849
You are going down the wrong track. Learn about Normalization.

The presence of a record for a customer in the invoice table indicates they have previously purchased. Do not add a Purchased field to the customer table.

The check box should be driven by data from the Invoice table. A DCount is one way. However, with a DSum you could show the total purchase amount in a textbox.
 

Users who are viewing this thread

Top Bottom