HI All, I'm very new to caspio, but used Lotus Approached in the past.
Id like to design a database to manage our customers, stock and invoicing etc. on my web site.
Ive seen tht caspio can do reports from one table, but for invoicing it needs to show data from 3 related tables.
ie. Id like a report to show T.C customer table T.I invocie table T.P products table
An invoice report would then show ( 3 different tables of data on one screen on the web site)
T.C customer Name
T.I invoice number
T.I invocie date etc
T.P products A Price
T.P product B PRice
Vat total etc etc
I was able to do all this on lotus, can can't think hwo to begin todo it on Caspio,
any ideas very gratefully received