I'm quite new to prog and facing a problem in "insert" using SQLITE. I have 2 tables like this:
1: reg_no (auto generated)(primary key)
1:reg_no (primary key)(foreign key from table1)
What I need is, whenever a new insert happens into "table1" an entry to "table2" also.
How can I know what is that auto-generated field in "table1"?
I can do this by using "select max()".. but it's increasing the steps..