In desktop, you can set up a field in the field rules to be a lookup of another database. That field rule can also populate other fields. This works great and I have used it often. However in V11 Server, this does not seem to work as well. Users, for the most part, want to make their input of information fast and easy, especially if there is a lot to do!
So maybe I never noticed this before, but I have a grid with a detail section. One of the fields in the detail section is called "Actcode" which is a two letter code, which in turn looks up another dbf and fills in various fields. The issue(s) is/are this. If the user types "pu" (small case) in the lookup field, there is no warning and the input is accepted, even though that two letter form exists, albeit as "PU" in the lookup dbf. Somehow in desktop this works ok, but not in the server version. Also, even though I have checked "Honor Field Rules", these rules are not honored, the data of "pu" is accepted and no lookup occurs. Maybe this was some kind of oversight or I never noticed this, but I need to get this to work. In the same vein, I noticed that if I enter "pu" then a dropdown list comes up showing "PU", so I could select that and it will work, but again, a user doing input would most likely miss this. Pointing and clicking each time is cumbersome.
So, I need to either transform the "pu" to uppercase before the lookup or not allow the user to continue, until a proper selection is made. I can't seem to do either one successfully.
Also, I reported what I think is a bug, the fact that when using a lookup that contains an image field, that image is not brought over to the new dbf in the lookup. In fact, it returns an error.
Any other ideas or workaround on this would be most appreciated!
Charlie
So maybe I never noticed this before, but I have a grid with a detail section. One of the fields in the detail section is called "Actcode" which is a two letter code, which in turn looks up another dbf and fills in various fields. The issue(s) is/are this. If the user types "pu" (small case) in the lookup field, there is no warning and the input is accepted, even though that two letter form exists, albeit as "PU" in the lookup dbf. Somehow in desktop this works ok, but not in the server version. Also, even though I have checked "Honor Field Rules", these rules are not honored, the data of "pu" is accepted and no lookup occurs. Maybe this was some kind of oversight or I never noticed this, but I need to get this to work. In the same vein, I noticed that if I enter "pu" then a dropdown list comes up showing "PU", so I could select that and it will work, but again, a user doing input would most likely miss this. Pointing and clicking each time is cumbersome.
So, I need to either transform the "pu" to uppercase before the lookup or not allow the user to continue, until a proper selection is made. I can't seem to do either one successfully.
Also, I reported what I think is a bug, the fact that when using a lookup that contains an image field, that image is not brought over to the new dbf in the lookup. In fact, it returns an error.
Any other ideas or workaround on this would be most appreciated!
Charlie
Comment