mercredi 23 mars 2016

A table that contains first two items in all other tables

I am working on an android app. Each of the content of my menuitems are stored in a local sqlite database. I want to create a table for my homepage, such that, this table always contains the latest two items of all the other tables in each menu. This homepage table should also update itself automatically, when the items in the other tables change.

In short a table that always points to the last two items of other tables. So I can query this table to display latest items in my homepage. Any help will be appreciated. Thank you.

Aucun commentaire:

Enregistrer un commentaire