Query for Related Records on Related List

[Nic Omaha]

Having some trouble writing a query for my relationship. I have a custom table called "u_ppi_database". Records on this table can generate a

"REQUEST" which I have populating on the form as shown below. The field on request is "number" and my custom field is "u_request_number". I am trying to get a

related list that shows the request in that field above. Everything I try either shows ALL requests or none at all.

CUSTOM TABLE

[Raghu Loganatha]

Nicholas,

Do you have any field on the Requests table which captures the number or name of this record (Record from u_ppi_database) ? You need a tag on the request number with this record to populate. If you don't have one , then create and try.

[Nic Omaha]

I do not and was hoping to avoid that. Does it not work with the reference field on the custom table comparing against the number field on request?

[Arnab Karak]

Hey Nicholas,

Create a custom field in the "u_ppi_database" and set the field type as "reference" to the request table. Add some data in the u_ppi_database table, in this way you will be able to add the related list in the request table. But not in the custom table, i think.

[Nic Omaha]

Thanks, I already have the field as shown in the first screen shot but I need the related list on the custom table not the Request table. I was hoping it could take that field and match it to the Number field on the request table.