Invoicing Stock Control And Customers

[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

 

 

 

 

[Jan]

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.