Selecting layouts by calculation
Hoping someone can help, my script writing skills are quite basic.
I have a database where the majority of tables are linked by order number. I want to write a script where the user enters an order number in a custom dialog box and then the script looks at a field in a table called "New order" related to this order number called "Product" and depending on what it finds in this field opens up a specific layout and displays the information from another table called "Orders" related to the same order number.
Any help would be greatly appreciated.