I'm new to appian and hope people can help with my newb question.
Tables Involved: Project, Request
Project Fields: projectId (PK), projectName
Request Fields: requestId (PK) , dateRequested, projectId (FK)
I'm currently at the record type that I have for Request table. Now, I want to display the projectName field from the Project table in this Reqeust record type. How do I do that? Is the PK-FK relationship enough to do it?
Discussion posts and replies are publicly visible
Hi saarcenal,
You can create one more record named Project and in same Project record , you can specify one to many relationship with Request record with PK - FK. Or, you can add relationship with Project in Request record as well with many to one relationship, anyway it will work.
Once this is done, you can use whatever fields you need from both records.
https://docs.appian.com/suite/help/21.4/record-type-relationships.html
Thanks Vinod! I have my project record already but request record has many to one relationship with the project and appian's aggregate related fields function is only okay for one to many. Will it be possible to do this in many to one via expression mode?
As far as i know, establishing record relation in expression is not possible. I believe you can easily refer projectName column with many to one as well. Can you show me some example of what are you doing?
Yeah a custom record field shouldn't even be necessary in this case. Once you establish your relationship, you can directly reference any fields from related records. So for example, if you want to pull data from the project you would do something like recordType!Request.relationships.Project.fields.projectName
Hello Peter! I am able to apply what you mentioned after making the table relationship flat. Thank you!
Hi Vinod! I was able to figure it out already. I should make the table relationship flat. thanks!