advise on variable joins

  • hi, I have a situation where we want to compare a defined student dataset to a 2010/11 plan (basically a recruitment plan per month by course or employer or salesman) within a multiuser app.

    A user thru a dropdown will be able to fix the project "join" eg they may pick "employerid" or "courseid" or a "salesid". This will enable them to contruct a plan where (eg) employer is the link between their plan and student dataset. Another user may want to link on courseid and the student dataset. However they will need to run the same reports and the logic (based on their login) derive the join

    Any thoughts? Hope it makes sense!

  • It would be easier to answer if you provided the tables, the relationships between them, and what data you are going to return.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply