Android Question any Example with Parent / Child using SQLLite

[Bhrt60]

Need to create a Invoice system

I'm looking for a example with Parent - Child relationship

So need to have 4 Tables

Customer Details
Invoice Header
Invoice Items
Stock Details

Each Invoice Header has multiple lines or Invoice-items which are related to the invoice Header (1:Many Relationship)

Customer is used as a Lookup only - fields from Customer details populated into Invoice Header ie. Account, Company, Address etc. (NO Normalisation)

Same with the Stock Record. This is used for Invoice items to lookup Stock details and populate the data ie. Stock Code, Description, Price, Tax Code etc. - into Invoice Items (again no normalisation)

 

[Haris Hafeez]

What kind of help do you need? It looks like you need to look into/learn SQL.

 

[DonManfred]

See dbutils tutorial example
There is a master-detail relation between students and grades

https://www.b4x.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/#content

 

[klaus]

Did you have a look at the B4A User's Guide ?
Chapter 5 SQLite Database
and more specifically
Chapter 5.9 SQLite Database forth example program SQLiteLight4