I’m very new to LibreOffice. I have a good idea of relationship databases as I have made a few access databases. But LibreOffice is quite different. In access, combo box allows bounded columns which can be edited. I could then add a vba to add new entry if the table doesn’t have this record. How can I go about this. If this is not possible, it means I won’t be able to use base.
so basically I would type in the customer’s name for example. If its not an entry in the table, it would prompt me to create one. Once the the new entry is created, I would later open the form that will populate the rest of the details like location and phone number. Or for example I would type in a product or material or location. The use cases are endless.