Text box addition

[clyons]

I have a problem, I've got a form linked to a table cell using text. An operator enters their user number and then saves the form, another operator goes to update this form and the previous operator is called. How can I get that form to show a blank box but add a comma to the first operator number and then add the second input from the operator.

Did that make any sense?

 

[vbaInet]

Didn't get that. Elaborate.

 

[clyons]

So we have multiple operators producing items, one opens a form enters the order number, operator number, what he did and saves it. That goes to a table which has the data. Another operator scans that order number which populates the part number and operator field. What im trying to do is get it so that a second/third/fourth operator can enter their number into that field and it will add that to the table cell with commas

so

First operator enters his number : 1
Second operator can enter his id so it would go 1, 2

so on and so forth.

 

[vbaInet]

Is this a multi user environment or just a single interface with different people working on it?

 

[boblarson]

You should NOT be storing data like

1, 2 etc.

You ADD RECORDS for EACH operator, not add them in using a comma. Getting meaningful data back out will be a nightmare for you if you continue on that path.

 

[clyons]

The only reason I want to do it is just so that I know who was updating it without having too many data fields.

 

[clyons]

its a single user environment.

 

[vbaInet]

boblarson is correct. It's a matter of combining the records for each operator and sorting by date

 

[clyons]

any word of advice on how to do that?

 

[boblarson]

Can you post your table structure here so that we might be able to make a suggestion or two?

 

[clyons]

I uploaded a copy of the table in excel format, what im trying to do is have the shift 1 operators show each operator that logs in.