How can we link a customer to a vendor and consolidate his balance ?
Put the Vendor No. as a field in the Customer Table. You could also put the Customer No. in the Vendor as a crossreference. Either way, it should allow you easy access to buile balances. Bill Benefiel Manager of Information Systems Overhead Door Company billb@ohdindy.com (317) 842-7444 ext 117