• seeing that it will be around 1 AM, probably not. But if you post a simple description of what you're modeling and then your model (create table scripts with the foreign keys in there), someone can help you.

    Can you post a really simple description of what you're modeling? Start with two tables (parent and child) and work your way out. If you try doing everything at once, you're going to get really confused. (Been there, done that!) If you think you have it down, then add a few records to the two tables and see if you get the right answers from your query. (Add only enough records to verify your design is right - you can delete the records later.)

    Hope that helps.