Database View - One to Many relationship

[k_yamamoto]

Hi,

I'm trying to create a database view that has a one-to-many relationship.

I have to implement this requirement because of a plugin's limitation that I will use.

These are tables I would like to join.

・Table A（Referenced by Table B, has multiple records of TableB）

・Table B （References Table A）
　Column b1（Reference field to Table A）

I would like to show these tables as below picture. （One Table A record has multiple Table B records as a related list.）

I created a database view as below.

Table A : Prefix a

Table B : Prefix b

Where clause : b_u_column_b1=a_sys_id

But it didn't work as I expected. It seems that the database view has one-to-one relationship.

Does anyone know how to create a database view that has one-to-many relationship?

Thanks.

[Jaspal Singh]

Hi,

Unusre, of the expectation. However, you can set Left Join True for one-to-many relationship.

You can add it is as a field on the view tables form/list

[k_yamamoto]

Hi, @Jaspal Singh 
Thank you for your reply.

I set Left Join to True, but it didn't work.