Need advice on creating one to many relationship between two custom tables

AmritaT
Tera Expert

I have created two custom tables tab A and Tab B. I can create records on Tab B from Tab A. 

e.g creating problems from inc table.

As per the document, I have created a m2m relationship -

Step 1 -

find_real_file.png

Step 2 - Add the related list to the table -

find_real_file.png

Step 3 - ??   I'm not sure what else to do to add the list of records to be seen under this related list.

 

E.g - I want to be able to see the contracts under the addenda as given below in the screenshot for incident and problem -

find_real_file.png

Please advice. Thank you.

 

 

 

1 ACCEPTED SOLUTION

ggg
Giga Guru

if table A is the parent and table B is the child

create a field on table B of type "reference" and select Table A as the reference table.

Then go to table A, right click at the top of the form, select Configure >> Related Lists >> select your related list.

The child records appear at the bottom of the form.

View solution in original post

11 REPLIES 11

 

I'm trying to create the similar relationship for my custom table as highlighted below in the screen shot -

find_real_file.png

Can you share the screenshot of your related list on table A

find_real_file.png

Please Move Addenda -> Contract Number to selected and try to create a record using the new related list

 

This relationship you see on the 'Available' list is from M2M table. It doesn't work anyway.