Thanks for replying Alister.

I've attached a text file with that will create two tables; the budgets table and another table I've called a view, purely because in real life I've...

Thanks, I'll check that article out for the future... I ended up re-installing and choosing mixed authentication..

Cheers for the help

Paul

Hi folks,

I know it's been a while. I've now tried your suggestions RBarryYoung and it worked fine. Like to thank both of you for your help.

Paul

I really appreciate the help. I'll look into it and get back to you to let you know how I get on.

Cheers

Paul

I'm still not sure... There's something I'm not getting. The new dates and rates are handed to me by management and are not actually in a table within the db.

That's...

Thanks Chris for getting back to me.

I've already done this. This is my problem. I don't know how to take the output which you suggest and add new rows along...

Sorry I haven't been in touch until now.

I've not tried it out yet because I've not got to the reporting stage, However, I'll be developing that side soon. I'll let...

Hi Karl, thanks for your response,

Heres what I did, The Client table is parent of Project and Project is parent of Milstone, now since there are only 7 milestones (and...