First time here? Check out the FAQ!

Reference key/id between Agent, property and office

RETS URL : Username: CCAR_Mooveguru

I want to link agent with property and property with the office. Can anyone tell me which is the reference key or ID to link with all three, because the property has more than 350 fields on his table.

Thank you in advance.

chaitanya's avatar
asked 2018-02-06 04:27:46 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


L_ListAgent1, L_ListAgent2, L_SellingAgent1, L_SellingAgent2 link to U_AgentID in Agent and ActiveAgent resource.

L_ListOffice1, L_ListOffice2, L_SellingOffice1, L_SellingOffice2 link to O_OfficeID in Office and ActiveOffice resource.

We also include some limited agent/office info in the property resource in fields with prefix: LA1_, SA1_, LO1_, SO1_, etc.

bwolven's avatar
answered 2018-02-06 09:22:08 -0500
edit flag offensive 0 remove flag delete link


@bwolven Thanks for an explanation. It helps a lot.

chaitanya's avatar chaitanya (2018-02-07 04:03:53 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer