Community
Showing results for 
Search instead for 
Do you mean 
Reply

data validation

Highlighted
Astute Commentator
Posts: 17
Country: USA

data validation

is there any functinality available in ACT 16 premium, that on entering data it retrieve data from the other data base file of ACT. like I have two data base Manufacturer and buyer, If I want to add a new buyer it check first does it exist in manufacturer or not. 

Highlighted
Gold Contributor
Posts: 3,831
Country: United_Kingdom

Re: data validation

You can't compare contacts in two different databases, which is why it's often more useful to put ALL the contacts in a single database but "flag" them is some way to distinguish the two groups. Fore example, use the ID/Status field to classify each contact as a Customer or Supplier. Now when you add a new contact you can use the built-in duplicate checking to alert you if the contact is already in the database.

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk