Elías needed more than tables. He needed advanced forms .
He built a main form called Menu_Director . It wasn’t pretty, but it was powerful. At the top, a subform showed a live bar chart (using a simple macro to refresh a grid) of sales per hour. Below that, he placed a list box that filtered PRODUCTOS by category: "Tacos," "Tortas," "Bebidas." libreoffice base formularios avanzados
But the magic was a button labeled When clicked, a macro ran a query that opened a second form listing every product with less than 20 units left, automatically sorted by supplier. The manager could now order empanada dough before the lunch rush even started. Elías needed more than tables
That’s how Elías met LibreOffice Base . It wasn’t pretty, but it was powerful
The waiters hated the old POS interface. So Elías designed Formulario_Rapido . It was a single, massive form based on the VENTAS table, but with a trick: he used a for the sale details. A waiter would select a client number from a combo box (which auto-filled the client's name and loyalty points), then scan the product barcode into a text box.
His breaking point came during the "Great Empanada Shortage of October." A supplier had been paid twice, a new cashier couldn't find the "elderly discount" button, and the kitchen ran out of dough because the inventory sheet was three days old. His boss, Doña Chelo, handed him a stained notebook. "Fix it, Elías. But we have no budget. Use the free one."