Hi,
I need some help understanding how to get to the following result:
The app has a table called orders, this contains customer orders and all related info. It also has other tables like 'customers' or employees, that hold additional info that is always the same for the items in that table (name etc).
When entering a new order in a form, I want to auto-fill/populate some fields based on the customer selected. (for example customer X will always have payment term 'PF', and incoterm 'FCA' , which are columns in the customer Table).
It's probably very simple, but I am stuck in overthinking mode on this I'm afraid.
Thanks for the help!
LinkedIn
Twitter
