Need a button to update a table

[Design by Sue]

I am trying to create a form that a mechanic in a factory can acces, type in
the part number - suffix of a part and assign it to a production line.

I have a table (PartSuffixTbl) that includes PartNumber and Suffix that are
entered through an administration form. (The mechanics have to only access
this information and are not allowed to change it.) The table also includes
a field for Line. (This is the field I have to update) I have created a
query(Part-Suffix Query) that combines the PartNumber and Suffix to display
as one field PartNumber-Suffix (Expr1). I have created a form with 10 combo
boxes and set the row source for each of the of these as the Part-Suffix
Query.Expr1 and included hidden fields for both PartNumber and Suffix. (This
is to give the mechanic the possiblity of adding 10 parts to a line at one
time) I have also created an unbound text box with a row source to another
table that lists all availabe line numbers.

I hope this is the correct beginning for what I want to do, which is, I want
to create a button that when clicked adds the line number to the
PartSuffixTbl for each of the 10 (or less) PartNumber-Suffix(s) selected in
the combo boxes.

Sure hope I stated that clearly enough to get some help. Thanks in advance.

 

[Dennis]

I guess I don't understand the problem. Your requirement seems simple enough.

May I assume that "lines" become available or unavailable through some
real-time emchanism? If so, how would you get that information into your
database in a timely manner? If not, what makes a line available (or not)?
The actual mechanics of adding a line to the table entry are pretty trviail;
the underlying issues I outlined being more complex by far.

Dennis

 

[Design by Sue]

The mechanics are removing the parts from the stock room and putting them on
an assembly line. They physically have the parts in hand when the do the
assignment. Not sure if that answers your question.

BUT in the meanwhile I was able to solve the issue (or seemingly so) with a
"DoCmd.RunSQL" statement on the button

 

[Dennis]

Well, you talk about an "available line." How do you/they know which line
would be available at any given time? (FYI, my primary expertise is in heavy
manufacturing real-time automated data-collection and control systems, so I
approah your questions from that perspective.)

 

[Design by Sue]

Assembly line

Well, you talk about an "available line." How do you/they know which line
would be available at any given time? (FYI, my primary expertise is in heavy
manufacturing real-time automated data-collection and control systems, so I
approah your questions from that perspective.)

 

[Dennis]

I understand. But you haven't yet told me how you know what line to assign a
part to? How do you know what line is available for the part at the time it's
picked? THAT answer will determine how you assign the line to the record.

 

[Design by Sue]

Thanks, but I have solved that problem, now I am on to another.