2 Replies Latest reply on May 11, 2015 4:25 PM by philmodjunk

    Real estate



      Real estate



      I'm creating a db with fm 13 that has 2 tables: Buy requests (Area, min sq m, max price) and sell requests (Street, area sq m, price).

      Obviously I have a table with all the datas of a client (Name, tel, mail) and with a primary key (Id Client). The other tables have foreign keys (IdClientForeign).

      I'd like to match the buy requests with the sell requests in order to have a new table with all the apartment that could be interesting for a client (And all the clients who could be interested on a certain apartment)...

      I guess I should create a new table but I don't undesrtand which fields this table must have and which relationship should i create...

      Can u pls help me?


      Thanks in advance,