Hi does prisma automatically locate relation? for example user has one profile then I want to update the profile of the user using user id as the pointer will work the same as using the profile id of the user?

Yes it should work.

Thanks @Ryan it works!