Stock Control Form

[mea99sdp]

Hi

I'm trying to design a stock control database, I could do with some help, I would like a form that looks like this

Date (Today)

Title - Part Name / Part Code / A Shift / B Shift / C Shift / D Shift

Lists part 1 / code 1 / qty box / qty box / qty box / qty box
part 2 / code 2 / qty box / qty box / qty box / qty box
part 3 / code 3 / qty box / qty box / qty box / qty box

record button / cancel button


if a value is entered into qty box, it records date/shift/part name/qty issued in a table then updates main table (stock qty) that stores part name/part code/stock qty/reorder level.

Can it be done?

Cheers

 

[zyxwvu44]

i think what you want is a continuous form, which will update as you fill it in if its linked to the table directly.

 

[mea99sdp]

Ok, but how do i show the partid/part name/ part code from one table, and a qty box on the end, when the qty box is filled it stores the part details and qty to another table

 

[neileg]

Have you done a search in these forums on stock control or inventory? There's lots of help.