question Table relationship for two tables in App Engine forum

Table relationship for two tables

VikramM1 — Sat, 13 Apr 2024 18:35:52 GMT

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

Re: Table relationship for two tables

Astik Thombare — Sun, 14 Apr 2024 05:26:24 GMT

Hi @VikramM1 ,

You can create a relationship between two tables by creating a reference field on your custom table and point it to another table this is a basic relationship which allow the relation between two tables.

Please Follow Example -

I have created two Tables - Table A and Table B

Table A-

Table B -

Then I have create one field on Table A (Reference to B ) that is referencing to table B

Once this is done we need to create relationship between these two tables

Navigate to System Definition -> Relationship

In Relationship we need create relationship between these two tables

to know more how to create relationship follow link -https://www.servicenowelite.com/blog/2014/2/6/show-attachments-related-lists

Once this is done we need to add related list to table A

Right click on Table A form -> Configure -> Related List

Add Related list to table A that we have created

Once that is done you are able to see related list at the bottom of Table A and you will able to create new record for table B using that related list

Thanks,

Astik

Re: Table relationship for two tables

Community Alums — Sun, 14 Apr 2024 05:17:06 GMT

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

Re: Table relationship for two tables

VikramM1 — Sun, 14 Apr 2024 06:01:35 GMT

Hi Astik, thanks for your reply. but, i dont have any reference field with table A.

Re: Table relationship for two tables

VikramM1 — Sun, 14 Apr 2024 06:02:26 GMT

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

Re: Table relationship for two tables

Astik Thombare — Sun, 14 Apr 2024 06:03:52 GMT

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

Re: Table relationship for two tables

Community Alums — Sun, 14 Apr 2024 06:49:37 GMT

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

Re: Table relationship for two tables

VikramM1 — Sun, 14 Apr 2024 16:50:06 GMT

Okay got it

Re: Table relationship for two tables

VikramM1 — Sun, 14 Apr 2024 16:50:39 GMT

Okay got it thanks for the information