lookup object with edit form
Posted: Mon Jul 16, 2012 12:26 am
Hi, I would improve the autocomplete function of a lookup object to give users the possibility to insert a new record if the autocomplete function have a negative search.
Now the users can search the record in the customer table using autocomplete or lookup function, as they want, but if a record doesn't exist the job isn't so simple.
They have to:
- open the browse table by the lookup object;
- push the New button to open the edit screen;
- insert the new record and save;
- select again the record just inserted to populate the lookup object on the table (hoping it's in the first page, otherwise they have to find it with the form search field!);
Is there a simpler method?
My idea is to give the users the autocomplete function and, if the record don't exist, alert them if they wanto to insert a new record: if they answer yes open the edit form, insert the new record and, when saved, populate the lookup object.
Is this a wrong idea?
Any suggestion will be apreciated.
Now the users can search the record in the customer table using autocomplete or lookup function, as they want, but if a record doesn't exist the job isn't so simple.
They have to:
- open the browse table by the lookup object;
- push the New button to open the edit screen;
- insert the new record and save;
- select again the record just inserted to populate the lookup object on the table (hoping it's in the first page, otherwise they have to find it with the form search field!);
Is there a simpler method?
My idea is to give the users the autocomplete function and, if the record don't exist, alert them if they wanto to insert a new record: if they answer yes open the edit form, insert the new record and, when saved, populate the lookup object.
Is this a wrong idea?
Any suggestion will be apreciated.