Linking one database to another

Need help Database
1

Think of this in an AirBnB context.

I have a user database where my users register as either landlords or tenants. This part I have working smoothly.

Now I need landlords to be able to upload their properties, and all the details that go with it. The part that I am struggling to get my head around is:

  1. I assume that it would be best for me to create a “Properties” database, but then I would need to link the Properties database to my users, as Landlord A’s properties need to be connected to landlord A.

  2. Then I need to be able to display ALL properties on the system in the same place so that the tenants can brows properties.

Any ideas?

2

Hey @bertr4n :wave:

Yes, you need to have a ‘properties’ database type and have a landlord attached to it, which would be your user. :blush:

Yes, you would use a repeating group to display all properties to everyone so that the tenants can browse them. Double check your privacy settings so you are only exposing the information that you want to though.

Does that help at all? Let me know if you have more questions. :blush:

3

Thank you for this. I have created the properties Database, but I am not sure how to get a landlord attached to it. Please assist.

4

When the user creates the property, save the current user to that property under a field called ‘landlord’ or something like that. Does that make sense? :blush:

1 Like
5

This worked! Thank you

1 Like
6

Awesome! :clap: Glad that helped. :blush: