Looking at a table for particular field before updating

[StuartW]

I have a database for creating schedules on a workshop floor

In this database I have a form which requires a user to enter the model and serial number of the unit they wish to make and the quantity. Along with Run number, start date and finish date.

I want the form, from an enter button, to populate a table and create X records of this type. There is an Autonumber in the table for the key.

Just to add another dimension, I also want the code to look up the table first and find and recods which are not allocated to a run number of this particular model and serial number, and include this in X to be created......

Any Ideas? I may be over my head here.

Cheers
Stuart

 

[cpuSmoker]

Let's see what u got

It doesnt sound that difficult, but may require some vb coding behind the scenes to make it work. Would you mind posting what you have so i can chat with you about getting it to work for you?