Sales Invoice to mysql

[Juan_Antonio]

Study if you can use related tables, here is an example with Sqlite:

Related tables. SimpleSqlite extension. Pharmacy example

- New version, add quantity of boxes. In this version we can add the number of medicine boxes assigned to each patient, for example to Miguel: 2 boxes of Aspirina, 3 boxes of Ansiolitic and 1 box of Dolorin. p55H_Sqlite_Farmacia_v2.aia (35.3 KB) [sqlite14] -- Create table intermediate pacientes_vademecum for relation many to many CREATE TABLE IF NOT EXISTS pacientes_vademecum ( pacientes_id INTEGER, vademecum_id INTEGER, cantidad INTEGER, FOREIGN KEY (pacientes_id) REFERENCES paci…