I am not too clear on what you are asking for, so I shall give you a solution to what i think it is, if i am wrong, post back with further queries.

First of all what tables you need depend...