Link customer to vendor

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 (317) 842-7444 ext 117