How to concatinate Customer And vendor data

DynamicUser

Hi friends
Can anybody tell me how to concatinate Customer and vendor table into one form.

kriki

You can try with a subform, that is the easiest way.

Another is that you put the fields of the vendor in the customer card, but you have to maintain them yourself by writing code in some trigger : "Form - OnAfterGetCurrRecord()", "Form - OnInsertRecord", "Form - OnModifyRecord()", "Form - OnDeleteRecord()".

DynamicUser

Requirement is for the list form.I hv to do it right now.How can i do?

kriki

This is for the customer-list form and putting some vendor-fields on it.
you can also use the vendor-list form and put some customer fields on it.
In this case, everywhere I use Vendor, you need to use Customer and vice versa.
OnAfterGetRecord-trigger:

recVendor.GET('some vendor');

The fields you add on the list, you need to write recVendor."Some Field".

Remark:you cannot filter on those fields.
In you need to filter on the fields, you need to put them in the customer table as flowfield that points the the vendor-table.