I have a lookup definition in a table for the field "company" as follows
lookup styles: Table Lookup
Table: cust.dbf
Linking field: company
display order:
filter: type="Customer.andActiveinact="Active"
Several fields fill in
Browse layout to display Customer Bill Address (this is a saved browse layout)
allow exceptions: Popup on mismatch
When a user is entering an invoice in the "company" field, they type in a part of the company name, hit enter, the list of customers appear, they choose one and it fills in the company, etc...
The problem is that sometimes the user types in the name and instead of the list of customers (customer bill address saved layout) they get "cannot create lookup. lookup definition not found" or something like that.. and there is no list... if they kick everyone out and "reindex" it will most of the time "find the list" again, but only temporarily until it happens again... but i've also seen it where if you just wait a few minutes and try again it will find it...
I've searched the archives and can't find a solution, and may have already posted this, so sorry if this is redundant.
I just can't figure out what the issue could be? It doesn't seem like it's indexing, although that usually solves it, but i'm at a loss at this point. If it a programming error on my part, i'd love to find it, and if an alpha bug, i'd love feedback on what to do to fix it?
Anyone have this happen?
lookup styles: Table Lookup
Table: cust.dbf
Linking field: company
display order:
filter: type="Customer.andActiveinact="Active"
Several fields fill in
Browse layout to display Customer Bill Address (this is a saved browse layout)
allow exceptions: Popup on mismatch
When a user is entering an invoice in the "company" field, they type in a part of the company name, hit enter, the list of customers appear, they choose one and it fills in the company, etc...
The problem is that sometimes the user types in the name and instead of the list of customers (customer bill address saved layout) they get "cannot create lookup. lookup definition not found" or something like that.. and there is no list... if they kick everyone out and "reindex" it will most of the time "find the list" again, but only temporarily until it happens again... but i've also seen it where if you just wait a few minutes and try again it will find it...
I've searched the archives and can't find a solution, and may have already posted this, so sorry if this is redundant.
I just can't figure out what the issue could be? It doesn't seem like it's indexing, although that usually solves it, but i'm at a loss at this point. If it a programming error on my part, i'd love to find it, and if an alpha bug, i'd love feedback on what to do to fix it?
Anyone have this happen?
Comment