Easiest Way to compare two recordsets

comparing two records

[Jeff12]

Hi everyone,

I would like to create a site that allows the user to compare two different record sets (two different company profiles using the same criteria). There are about 100 criteria that I am recording for each company. What is the easiest way to allow the user to pick two companies out of a larger list of companies to compare the two records side by side? And which would also allow them to select certain criteria to compare between these two companies, or all the companies at once? So that they could create a list of companies that have criteria a, b, c, f, etc. etc.

What is the easiest way to do this...code it myself (I'm not a programmer, but have some familiarity with various database technolgies etc.). Or can I customize an existing, simple and preferably Open Source content management system?

Thanks for your answers!

Jeff

[Jeff12]

Bumpity bump bump...bump?

thanks... :)

[grandpa]

I think your use of the word 'easiest' may be off-base :) It sounds like you are going to need some complex custom code.

Since you say you aren't a programmer then it could be a difficult task. But there is one thing you can do to get started, which will not only help you clarify the process but will help a programmer write the code too. Start with a clean sheet of paper and create a flow-chart of the entire process. Now it's possible to write chunks of code that perform a specific task. Then it becomes a matter of putting all the pieces together.