Skip to Content
0
Former Member
Sep 01, 2006 at 06:48 AM

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

16 Views

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.