How to bind tables

[Former Member]

I created two tables, called Customer and Order, as demonstrated in the example C:\Program Files\SAP Manage\SAP Business One SDK\Samples\COM DI\VB.NET\2.MetaDataOperations\2003. In each table I have a N_Cliente field. Now I would like across the field to bind (to relate) to these tables, N_Cliente of the Table Cliente and N_Cliente of the table Order. How I can you make it?

[former_member184566 · Accepted solution]

Hi Danilton Will

This example you are talkng about shows you how to do metadataoperations which is adding of tables, fields and userkeys. It does not have what you are looking for.

To me it sounds like you want something like sbo uses where they have a main table like oinv for invoices and another for the lines like inv1. Am i correct?? If you do want that then you should use udo, a udo will achieve that for you, it will also manage a numbering series for you. If you don't want that, and what you want is just one table to have a primary key, the other a foreign key, but the two are related, that you will have to do on your own and manage it yourself.

Hope this helps