When I query properties, I lookup listing office information. I use from Properties field [L_ListOffice1] and match to ActiveOffices field [O_OfficeID] This works for some but others there is no match.. This makes it hard to follow the TOS and display their (listing agents) information.
Am I matching up the wrong fields?
I have found the answer - only ActiveOffices is available to me. This is a bit troublesome as I can retrieve closed listings but some are from offices that are current non active members. I have asked Neren and await answer on TOS violation possibility if list property without credits of the non available agency...
I used to do a local Join like you but switched to grabbing the Agent & Office name from the Property rows. Unless you want to detailed Agent & Office info, you no longer need the Agent & Office tables. FYI, all the Agent & Office ids have changed.
Thanks Ryan, thats the route I took in the end...
Comments