Ask Your Question

Reference key/id between Agent, property and office

asked 2018-02-06 04:27:46 -0600

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.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-02-06 09:22:08 -0600

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.

edit flag offensive delete link more


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

chaitanya gravatar imagechaitanya ( 2018-02-07 04:03:53 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-06 04:27:46 -0600

Seen: 644 times

Last updated: Feb 06 '18