Table relationship for two tables

[VikramM1]

Hi,

I have created custom application in studio as per client requirement, i created table A(budget) with form. There is one more table and form linked with same form which is related items.

Both are having different fields, how to create relationship between both.

The user should be able to enter details of table B related items in table A form.

I want this to show relationship table below with new button, as there is no same fields in both how to create relationship. Is there any way

[Astik Thombare · Accepted solution]

Hi @VikramM1 ,

you need to create reference field . without that it is not possible . you can create field but dont show on form that could be a workaround .

Thanks,

Astik

[Community Alums]

Hi @VikramM1 ,

you can create Relationship by navigating - System Defination > Relationships.

Applies to Table - Table B where you want Related List

Query from Table - Table A where you want Reference 

Add below code 

current.addQuery('reference_field_name', parent.sys_id);

Please mark my answer correct and helpful if this helps you

Thanks and Regards 

Sarthak

[VikramM1]

I dont want to add any reference field, without that i need to create

[Community Alums · Accepted solution]

Hi @VikramM1 ,

You need any Reference field which is pointing to Table B, without that it is not possible to make any relationship with any table.

For example You have related list on Incident table with taking reference from User table, you have the caller field as the reference.

Please mark my answer correct and helpful if this helps you

Thanks and Regards 

Sarthak

[VikramM1]

Okay got it thanks for the information