Multiple Operations for a Job Order

[FlabbyRoach]

I will try that


Thanks

[FlabbyRoach]

aytee111,
Here is my database
I now have the sub forms on then main form.I think that is what you were asking.
ProcessSheets.zip

[FlabbyRoach]

Here is my db.
ProcessSheets.zip
I made a sub form on the main form.
Now i need to add about 10-15 process to the main form.
Thanks

[aytee111]

See attached. I have created new tables and new forms. Please note naming conventions, these are important, especially no spaces, no reserved words, and no special characters.

[FlabbyRoach]

OK
I will look this over and see if I can replicate your tables and forms.
It looks as though you using the form to populate the new items table; is that correct?

[aytee111]

Yes, that is the usual way of doing it, unless the data is coming from somewhere else?

[FlabbyRoach]

Can I populate the tables with textboxes on the forms or are they just for listing what is in the tables?

[aytee111]

Did you see the "New" button? That is for entering a new record in the SO table. On the subform, the last line is blank which is where you enter new records.

[FlabbyRoach]

I did see that
The customers and part numbers are list boxes and if i enter something other than what is on the last I get an error.

[aytee111]

That is called referential integrity - only allowing entry of valid data. You would have tables which contain the only allowable entries. Or else remove that and allow the user to enter anything that they want, if that is your design requirements.

[FlabbyRoach]

I would rather have the user input the customer name which will be held in the table.

[aytee111]

So you don't mind the same customer being entered multiple times? Acme Brush Company, Acme Co, Acme Brus Co, Acme Brush, etc. And each time you are going to add it to the table like that? I think it is time you did some tutorials on database design.

[FlabbyRoach]

Actually, I am more interested in getting all of the processes done for each SO Number.
The customer field will not be visible on the process sheet that is given to shop employees.
On this form the customer is secondary, I may leave that field off all together.

[FlabbyRoach]

aytee111,
can we append the customer field with the input from the user?

[aytee111]

Not sure what you mean by "append the customer field". The word append in Access means adding a record to a table.