W
Wacky Wednesday
I have a table in which product numbers are listed. The product numbers
change daily and by 30 different users who use them.
In addition, we have a form that our users update on a daily basis. My
question is what would be the best way to update the product numbers in that
form so that each instance of that product number is updated in the product
table? For example User A worked with five different products that day and
goes into the form to fill out what product numbers he used. I'm looking for
access to know to create a new row/column based on each product number, not
put all five into one cell.
Thank you in advance!
change daily and by 30 different users who use them.
In addition, we have a form that our users update on a daily basis. My
question is what would be the best way to update the product numbers in that
form so that each instance of that product number is updated in the product
table? For example User A worked with five different products that day and
goes into the form to fill out what product numbers he used. I'm looking for
access to know to create a new row/column based on each product number, not
put all five into one cell.
Thank you in advance!