On the customer tab of the order screen there is a checkbox for 'keep details private', and after reading some back posts I have figured out how this is supposed to work (and this is exactly what I wanted).
Unfortunately, I did not implement this originally and had used one of the 'user defined' boxes under 'General Information' to record whether or not the customer wanted to be contacted. And I now have a lot of customers...
Now I come to extract the data however I'm not sure if there is an easy way to get this information out (doh!).
Looking in the MDB file there is a table with all the customers in (person), and a table with all the user defined fields in (order). Is there any easy way to write a query that will produce a list of the people along with the information they entered intot he user defined field? (I'm completely clueless with access)
Unfortunately, I did not implement this originally and had used one of the 'user defined' boxes under 'General Information' to record whether or not the customer wanted to be contacted. And I now have a lot of customers...
Now I come to extract the data however I'm not sure if there is an easy way to get this information out (doh!).
Looking in the MDB file there is a table with all the customers in (person), and a table with all the user defined fields in (order). Is there any easy way to write a query that will produce a list of the people along with the information they entered intot he user defined field? (I'm completely clueless with access)
Comment