I need to create a link from the Customer table to the contacts related to that Customer. A simple link would be too easy. It seems that there is a “reference table” that holds the Customer Number, Company Contact Number, and the Contact Numbers. I have designed a form to show the Customer information in the top, and I want to show all the Contacts related to that Customer in a sub form below the Customer details. (much like the Contact List table does, but as a sub form). Can some either smack me up side the head and tell how easy this is OR give me giant push in the right direction. Thanks.
hi… In customer table there is a filed “Primary Contact No.” which is reference of No. field of Contact table. So You create Customer Form(Card format) and Contact Form(List Form). Add Contact Form as a subform in Customer Table and set the following properties. SubFormID:Contact SubFormLine:No.=FIELD(Primary Contact No.). As per my understing the problem is solved.
Would this not filter just on the Primary Contact though? I would like to show all the Contacts for that Company. The only way that I see I can do this is to use a reference to the Contact Business Relation Table which contains which contacts are related to which Customers (and Vendors, Bank Accounts etc.), and then display the appropriate Contact information (form the Contat table) in a subform. Navision already does this reference when you use the Look-up button for the Primary Contact in the Customer Card, but I don’t know how to make this work automatically using a subform. Any ideas?
look at code in customer table function ShowContact and use similar code to show contact list on any form