In my Invoice line Item, I want that If I enter my Catalogue Number, It will automatically fill my Product Item..
How can I do that?
A couple of different ways to do this. The non-scripted way would be to use auto-enter fields for your product info that uses a relationship based on the just typed-in catalogue #. That will only work if that catalogue # is unique obviously.
A scripted approach would do the same thing but would not rely on auto-enter field definitions. The script would pick up the relevant data from Products and use Set Field script steps to populate that data into the items table.
Thanks for the reply. I'm using the invoice starter solution. I added a Catalogue Number fields to the Invoice Data
and I setup my Catalogue Number field Look up (Start with the Table Invoice Data ; Look up from related Table ; Products | Looked Up ; Copy Value from field Item).
How can I setup my catalogue number field into an Auto Enter field?
Retrieving data ...