Hello, I have another table in which I want to implement the functionality of creating a new item card (or other table item) from typing it into (similar to) sales line.
I have a logic in mind which goes as follows
1. after typing into the line column, it will check the existing table for the item whether it exists or not
2. if it does not exists then it will provide a prompt message whether you want to create new item with that name
3. the typed name should be used as the primary key on creation of new item, it should not take the default number series.
4. it open up the card for filling up of further details
5. once done other related fields will get populated into the line
please suggest some references to get idea to work up with the code.
