Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Relational - Real State

Quote Reply
Relational - Real State
Hello

Im new to DBMAN SQL

I use dbman as a real state manager, I was capable of doing relational databases where one is for the agents and another for the homes

Now I want to do something like that

Table Agents*

- Description
- Phone
- Address (etc)

Table Houses

-Agent_id*
- Reference
- Address
- Value
- TIPE* (1,2,3,4,5,6...)

table_Tipe1(house)*
- bedroom
- bathroom
- etc

table_Tipe2 (apartment)*
- Floor
- Parking
- etc

table_Tipe3 (farm)*
- Square foot
- Trees
- Animals
- etc

Basically is that if you can understand

Now, how do I make this relation works? and how could the agents add those houses and just after add the respective description (tipe)? and for deleting?

The search will only works in the common table houses and the detailed view should get the respective house tipe

Any sugestions?