ricmason Posted February 1, 2014 Report Share Posted February 1, 2014 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 Regards Richard Quote Link to comment Share on other sites More sharing options...
0 Jan Posted February 4, 2014 Report Share Posted February 4, 2014 Hi! If I understand correctly, Views are used for joined Tables in Caspio. Views can work with several related Tables, and you can use View as a DataSource for your DataPages, e.g., for Reports. You can find more about Views in How-To, there is an article about Relationships in Caspio too. Quote Link to comment Share on other sites More sharing options...
Question
ricmason
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
Regards
Richard
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.