REQ and RITM status

[Simona6]

As I submit the request REQXXXXX is created with Approval and request state field which is in APPROVED state

RITMXXXX is created in Requested Item.

Requirement-User want as the REQ is created  Approval field should be 'Requested' and Request state should be 'Pending Approval'.If user Approve the RITM,Approval=Approved and Request State=Approved.If user reject,Approval=Rejected and Request state=closed Rejected.

Is it even possible?

What is the best way to do that and how?

[JagjeetSingh]

You can do it with workflow, Flow designer or with Business rule.

Whichever suits you go for it.

[Simona6]

I tried to do by workflow but i don't know what table I need to call to set the value for Approval and Request state.

[JagjeetSingh]

it is 'request' table where all the requests are stored and req_item table where all the RITM's are stored.

I'd find it easy to do in flow designer. But if it is applicable to all the requests then you can write BR on this.

Please mark helpful it helped you in any way.

[Simona6]

It is not working through workflow.