Don't know if this is the right forum - oops sorry wrong Forum B4A should be B4J !
I've been looking at B4J and SQLite
I have a 20+ year old DOS program which has structure below and would like to keep with that - well it works !!!
Customer
Account,Company,Address,City,PostCode
InvoiceMaster
InvoiceNo,Account,InvDate,OrderNo,Good,VAT,Total
InvoiceDetail
InvoiceNo,Line,PartNumber,Description,Price,Vat,Total
Invoice Master Has 1 to Many relationship with Invoice Detail
Customer table has 1 to Many relationship with Invoice Master
I've been looking at SQLite and MySQL and can't get my head around with ID & Foreign keys
I've been looking at SQLite examples but not seeing the wood for the trees I guess
can anyone point me in the right direction?
Account is ALPHANUMERIC
Invoice Sequence changes every year 100001, 110001, 120001 etc
I've been looking at B4J and SQLite
I have a 20+ year old DOS program which has structure below and would like to keep with that - well it works !!!
Customer
Account,Company,Address,City,PostCode
InvoiceMaster
InvoiceNo,Account,InvDate,OrderNo,Good,VAT,Total
InvoiceDetail
InvoiceNo,Line,PartNumber,Description,Price,Vat,Total
Invoice Master Has 1 to Many relationship with Invoice Detail
Customer table has 1 to Many relationship with Invoice Master
I've been looking at SQLite and MySQL and can't get my head around with ID & Foreign keys
I've been looking at SQLite examples but not seeing the wood for the trees I guess
can anyone point me in the right direction?
Account is ALPHANUMERIC
Invoice Sequence changes every year 100001, 110001, 120001 etc
Last edited: