Ask Your Question
0

Reference key/id between Agent, property and office

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

chaitanya gravatar image

RETS URL : http://maxebrdi.rets.fnismls.com/Rets... 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
0

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

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

Comments

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

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

Question Tools

1 follower

Stats

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

Seen: 50 times

Last updated: Feb 06