How to create relationship between tables using VB.Net

[Former Member]

How to create relationship between 2 or more tables in the SAP Business One. Example:Table Contract and Purchase, I want make relationship with NumContrat field using VB.Net

[Former Member]

Hey Carlos,

Can you give a little more detail about what it is you are trying to do?

Have you looked at the help files for the Conditions object?

[Former Member]

I want to make relationship enters 2 tables of my database in SAP, using VB.net. I would like that they explained me because, I created primary key and now I would to know as to relate tables!

[Former Member]

Sorry Carlos.

Are you just trying to query the information out of SAP using the DI code?

You can use a recordset object for this and set up your join directly in the SQL.

[Former Member]

In my work I created two tables: Customer and Order. The two tables have the Num_Cliente field. I would like to bind the two tables through Num_Clinte field.

[Former Member]

Hi Carlos,

Would you like to display this information on a grid? Data that is retrieved from two tables or what do you want to do with the tables?

Adele