How to implement one to many relationship between two Document Line Table

[Former Member]

Hi,

I want to implement the following relationship into user defined tables:

Example Situation:

There are tables A, B and C.

For one record of Table A, there could be multiple records in table B.

For one record of Table B, there could be multiple records in table C.

i.e. A(1) -> B(n) [One to many relationship]

B(1) -> C(n) [One to many relationship]

finally: A(1) -> B(n) -> C(n)

How can I achieve this? If I make Table A as Document and table B & C as Document Line and then make them UDO, will it work? Kindly suggest me a solution.

Regards,

Sudeshna.

[Former Member]

Hi Sudeshna,

This is not possible as you cannot have one table set as header and lines. There was a previous post about this. I'll see if I can find it and post the link here.

Hope it helps,

Adele

[Former Member]

Hi Adele,

Is there any other way to implement this situation in Sap Business One?

Regards,

Sudeshna

[Former Member]

Hi,

I think that the database representation is exactly what you ask for. 3 tables, A, B, C. A should have a UDF that is linked to B table, and B should have a UDF that is linked to C table.

You should manage the database transactions, and the UI to support all this stuff.

Regards,

IBai Peñ

[Former Member]

Hi IBai,

I am not aware of UDF.... can you tell me what is UDF and how to implement it?

Regards,

Sudeshna.

[Former Member]

Hi IBai,

I think you were referring User Defined Field as UDF. Thanks for you help IBai.

Regards,

Sudeshna.