How to create a Related List for String field, when the value matches to the another table.

[srilaxmi1]

HI Team,

I have a requirement.

I have a form which is pointing to Table A, it contains a custom field type is String.

Criteria to display Related List after Groups Tab:

1. TableA.published =true and TableA.Application ID==TableB.Application ID.

2. On The Related list, Display a New button. whenever a new record inserted on TableB, display a Parent value=Application ID this for the Reporting.

Screenshot: Table A

I have Table B, All application ID's are displaying here

Screenshot: Table B

How to achieve this requirement. Can anyone please help me.

[OlaN]

Hi,

You can create your own relation between these two tables by navigating to System Definition > Relationships

After created, add this as a related list by opening a record and select: Configure > Related Lists

[srilaxmi1]

But Table A having String field. How can i create a relationship between two tables if it is not a reference field.

1. TableA.published =true and TableA.Application ID==TableB.Application ID.

[OlaN]

By following the documentation (link I provided) you can create a custom relation, that does not require a reference relation. But you must write the query on how to relate the tables.

[srilaxmi1]

I have a created a Reference field on Table A. Now the Related List is coming.

But all the records showing, when i open any record. Record not found is coming. What could be the reason?

How should i solve.