The board is quiet these days, I thought I would create some action, so here we go again...:)
I have an Agent field (char, size 20) setup in FR as follows:
1) in Data Entry with a default value with expression user_name() at start of data entry
2) in LU to lookup value from Name field in Agents table
3) Validation: always required
On the layout the width of field object is 20. The largest user/Agent name in the table is 11 char wide.
Each user has a user name which is the Agent name.
Issue: when an agent creates an invoice sometimes a square (just 1 square) appears in the field on the layout instead of his user/agent name. When I preview the invoice the square is there.
When I open the Invoice table in default browse, the Agent field is empty although on the layout there is a square.
This is really random, not tied to any particular station, no tied to any particular name, not so frequent (happens 2 or 3 times a day with 9 agents creating invoices).
Note: I have a calc field to display the logged on user/agent name on the layout and it does show the correct name.
I checked the board and the help file.
I have been going in circle for the past few days checking everything I can thing of. I know it's hard to suggest a solution when the problem is random; just hoping that someone ran into a similar situation - thks
I have an Agent field (char, size 20) setup in FR as follows:
1) in Data Entry with a default value with expression user_name() at start of data entry
2) in LU to lookup value from Name field in Agents table
3) Validation: always required
On the layout the width of field object is 20. The largest user/Agent name in the table is 11 char wide.
Each user has a user name which is the Agent name.
Issue: when an agent creates an invoice sometimes a square (just 1 square) appears in the field on the layout instead of his user/agent name. When I preview the invoice the square is there.
When I open the Invoice table in default browse, the Agent field is empty although on the layout there is a square.
This is really random, not tied to any particular station, no tied to any particular name, not so frequent (happens 2 or 3 times a day with 9 agents creating invoices).
Note: I have a calc field to display the logged on user/agent name on the layout and it does show the correct name.
I checked the board and the help file.
I have been going in circle for the past few days checking everything I can thing of. I know it's hard to suggest a solution when the problem is random; just hoping that someone ran into a similar situation - thks
Comment