Need Help on my project: Simple Payroll

Hi Anakin,
Please find attached 2 versions of your payroll project to give you some ideas how you might want to tackle it.
Version 1 is more straightforward with hardly any script.
Version 2 uses more script to make the application more 'interactive' - it's more to show you the sort of things that you can do with MVD when you get more comfortable with it.
But just as with your 'maintenance' project, the basic principle of a hierarchy of tablegrids and forms is the same;  it's a principle that underpins pretty much any MVD project.
I'll try and have a look at your 'warehouse' question but from a quick glance at the spreadsheet, it will be much the same approach. 
One thing I'd suggest would be to use just one table ('movements') to hold all deliveries, despatches, stock adjustments etc with each row being identified by a 'movement type'.  It should simplify things greatly when showing things like stock holdings etc.
Regards,
Derek.

Hello Anakin,
Attached is an update of the project with the 'basic pay' showing as a discrete column.
A couple of other changes:
1)  all the numeric column headings, cells and footers are now right-aligned.
2)  the 'search' field accepts first name, last name, payroll id or position (basically, anything that you can see in tablegrid1 you can search on).
Hope this enables you to move things along a bit.
Derek.

Hi Anakin,
Added 'quantity' and 'amount' to give a Payroll Item total.
The way I've done it is that if a 'quantity' and 'amount' is entered, then the 'item total' is calculated.  But it is also possible to not enter anything in 'quantity' and 'amount' and just enter a value directly into the 'item total'.  If you don't need that flexibility, then you could force the user to always something in 'quantity' and 'amount' and make the 'item total' read-only.
Not sure why you would be getting a database locked error - changing the text of the payroll item doesn't touch anything critical in the table structure.  Is the error repeatable or was it just a 'one off'?
Derek.

Hi Anakin,
I hardly use Fast Report but I had a quick go at creating a 'salary slip'.
I'm sure you'll want to change the layout to better suit your own requirements but the data is all there and the figures seem to add up, which is the main thing that I was concentrating on!
Regards,
Derek.

Hi Anakin,
I couldn't easily work out how to get rid of the items with no values using 'report', so I used 'report(sql)' instead;  anyway, it's probably a bit more efficient to get rid of them in the initial selection rather than take them into the report only to subsequently remove them.
Derek.

Hi,
If you're meaning the extra lines with £0 values on the payroll breakdown, I don't know of any other way to get round it other than using 'reportsql' rather than 'report'. 
It's easy enough to not print out the item text and the zero value but that still leaves an empty line which doesn't look very good.
As I said earlier, I don't use FastReport very much so maybe someone else has some ideas.
Derek.