Help!

[THL]

HI,

I am making a database for a company that hires out equipment. I have made a form that is for booking the job in, it also has a subtable where the equiptment is listed with quantities. The job is taken out on the date, however at the moment the equipment comes out as soon as I complete the form. However this is untrue as the equipment is only taken out on the rental time, would it be possible to make it that the equipement stock levels are only reduced when the stock goes out on the specific dates to make the stock levels more accurate? and then on my form show the stock levels for the dates rather then the current stocks? the first part is more important as im sure this is not the easiest to sort through.

My second question,

When the stock is then returned I want a form that updates the stock levels in the equiptment table. However, I dont want all the stock to automatically be reentered in case there are things missing or broken? would there be a way to do this? and then make a note of the things not returend in anpther table?

Im sure this is quite a lot information to ask in one thread but I hope it is all understandable.

King Regards,

THL

 

[Ranman256]

it seems to me, you dont update stock levels.
you have the tInventory table, and a field that says that the Item is blank (in) or has a key assigned (out).
So a query would count that field and produce the inventory count. No entry to 'stock level'.

 

[THL]

it seems to me, you dont update stock levels.
you have the tInventory table, and a field that says that the Item is blank (in) or has a key assigned (out).
So a query would count that field and produce the inventory count. No entry to 'stock level'.

If I'm honest I'm not 100% sure where you are coming from. I need an update query that will only update the stock levels on the date rather then it being taken out straight away when the form is completed?