Several Dataset filtering on dynamic page and connecting to page elements

Hi, I am working on a real estate website. I have various tables in the backend. Some of them are as follows

Property →
Address->
Contacts->
Agent->
Buyer->
Seller->
Property Features->

Address, Contacts collections are general for Buyer, Seller and agents as all of them will have an address and contacts. Only property is general to address not the Contacts. By general I mean referenced.

What I am trying to achieve is:

  1. I have a dynamic page named (Property ID). which retrieves all data from different collections based on the user choice from another dynamic page (Property All). On the Property All page all the properties will be shown on a repeater. When user clicks on an item it will then be shown with all its descriptions on the property ID page. The information I need will need to be collected from all these different collections, which are related.

I need to show the Agent who is dealing with this specific property . Need to show
“Agents Name” → (Agent collection)
“Agents Email” → (Contacts collection)
“Agents Mobile” → (Contacts collection)
“Agent Image”-> (Agent collection)
'Property Address"->(Address collection)
"Property image "-> (Property collection)

The problems I am experiencing:

I am having trouble filtering the datasets . I tried to follow all your tutorials and the relevant forum posts, but couldn’t sort it out. Could anyone help me, with specific details on how to filter at least four collections through datasets. If I need to implement codes please advise how.

Also in the databases, Not every collection will consist of a field which can be used as a primary field. How can I use the system ID fields for users to input in the database in case of a referenced collection. The system field come as gray in the dataset.

I have few more questions, but not quiet sure how to put it in words at the moment…

Your help is appreciated. thank you.

Also I need to show this data on mostly textboxes. But if there is any other option i can use pls let me know.

Hi,
Use query to get the relevant data from each collection, in order to get the data of the referenced field add .include to your query, check out this article about it.
To show the data in text boxes simply set their text field to the relevant data.

Let me know if you need further help, good luck :slight_smile:
Or