Hi,
I am looking for some advice on creating a sales transaction database using CCK and Views on my site, http://www.rightsite.asia.
The problem I am facing is how to make a node refer to multiple nodes in a company database, and
the project I am working on is creating a database of commercial property transactions within an existing website of real estate listings.

  • The transactions would be nodes in the database, and I would like to use these nodes to gather trends and statistics on transactions
  • Would like to track buyers, sellers and agents involved in transactions
  • The key entry for any transaction is a property listing, and these are entered as separate nodes on the site.
  • Every property listing is associated with a company which is a seller, and these sellers are stored as nodes in the company field of the database. (The site has many sellers).
  • Every transaction has a buyer, and I would like to store these buyers as companies with these companies being saved as nodes in the same company field in the database. (there are instances where a company that buys in one transaction would be a seller in another transaction)
  • Transactions may also have selling agents and buying agents
    As the seller, buyer, selling agent and buying agents may already be listed in the site's company database, I need to find a solution that allows me to link each of these companies to a transaction node, preferably through node references.

    However, currently there's a limitation of one company node reference per transaction node

    Potential Solutions

  • Create content types based on the roles in the transaction for buyers, sellers and agents, with these role-based content types linked to the company field through node-references and the transactions linked to these companies through their entries in the role-based fields
  • Create a custom transaction module that includes the necessary functionality
  • Add the Ubercart module and set up the transaction database through its functions

    Does anyone have a recommendation the best way to approach this?

    • Comments

    jayaram’s picture

    jayaram commented

    I happened to be involved in the same kind of situation. Did you find a solution for this ?