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...
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...