My business manufactures various types of custom made orthopaedic splints (orthosis). Each type of splint requires a specific order form to be completed. For example we have a specific order form for foot orthosis and a separate form for knee orthosis.
I was thinking I would transpose our paper order forms onto their own libre base forms so that any form can be filled in as required. Although the forms would be separate I would require that their ‘Order Number’ would always follow on eg. Foot orthosis (order number 3) could be followed by knee orthosis (order number 4).
As well as all forms linking up to a single order number field I would like them to link up to general information like ‘Order Received’ and ‘Invoice Number’.
I hope I have been clear but I am very new to this as it is my first database. Thank you in advance.
(Using Windows 10, English, LibreOffice 5 Base)