Dear All,
I have a project with one BE and multiple FE users. Each user has its own FE connected to one BE.
My problem is that i have used combo boxes in forms that limits data entry to specific tables fields (Using limit to list property). I got conflict in data entry. To understand conflict go thru following steps that lead to conflict in data entry:
1- User 1 opens a form containing a limit to list combobox based on a table in BE
2- User 1 selects data from combobox.
3- User 2 changes data in BE table that leads to remove the specific data in combobox list that user1 already selected for combobox
4- User1 saves the changes and it saves. (it must give error here that combox data do not valid now.
To solve this issue, i came to know that index property of combobox solves this problem and it solved my problem. The only thing i now face is very small lag in data update. When user 2 updates the table, User 1 FE get this data in about 3 sec and before these 3 secs, list index property do not recongnise invalid entry and saves that combobox with invalid value.
So, my question is that how can i resolve that small data delay in updating linked tables to other users.
Thanks.
I have a project with one BE and multiple FE users. Each user has its own FE connected to one BE.
My problem is that i have used combo boxes in forms that limits data entry to specific tables fields (Using limit to list property). I got conflict in data entry. To understand conflict go thru following steps that lead to conflict in data entry:
1- User 1 opens a form containing a limit to list combobox based on a table in BE
2- User 1 selects data from combobox.
3- User 2 changes data in BE table that leads to remove the specific data in combobox list that user1 already selected for combobox
4- User1 saves the changes and it saves. (it must give error here that combox data do not valid now.
To solve this issue, i came to know that index property of combobox solves this problem and it solved my problem. The only thing i now face is very small lag in data update. When user 2 updates the table, User 1 FE get this data in about 3 sec and before these 3 secs, list index property do not recongnise invalid entry and saves that combobox with invalid value.
So, my question is that how can i resolve that small data delay in updating linked tables to other users.
Thanks.