I have an Add Page which contains two fields formatted as Dropdown. The first field displays "Suppliers" and the Second field which is dependant on the first field displays the "Supplier Contacts".
I would like to "Add New Record" on the fly to the "Suppliers" but of course I would also need to Add New "Supplier Contacts".
Can anyone advise me the best way to achieve this?
The "Suppliers" table and the "Supplier Contacts" table are linked as one-to-many.
Many thanks,
Carl.