I have a LibreOffice Calc file which I use for my invoices. From my website I have a export with my customer data (customer number, company name, customer name, adress, zip, city) which is also available in a Base Database.
What I want is the Calc file and the Base/csv database get connected with the following functionality:
- I want to select the customer number in a list-view in the calc-file (customers number from the base/csv).
- If I select that customer number the Company name, customer name, adress, zip and city field get filled in automatically according to the same row in the base/csv as the customer is in.
For example when in the base/csv are the values:
Customernumber, Company, Customer, Adress, Zip, City
JM-001, Building Company, A. de Boer, Homestreet 12, 1234AB, Eindhoven
JM-002, Construction Company, Z. de Vries, Nicelane 78, 9876ZX, Den Haag
In the drop-down in my calc file I select "JM-012". The Company name, customer name, adress, zip and city field get filled in to their fields to.
This should be a hard job. I think it is even possible without the use of any macro's.