Re: understand basics - multiple cars in a database - selection of one

On Tue, Feb 4, 2014 at 10:34 PM, avpro avpro <avprowebeden@gmail.com> wrote:
> let me write it differently:
> "when the application is lunched, I would like to select one car and then
> every property, option, transaction (applicable to this car) should be
> recorded by the application automatically. "
>
> the property, option, transaction should be recorded by the application
>
> hope this helps. thanks

Oh yes, line feeds definitely made it a lot more understandable!
I suppose what you need here is a good mapper for your application
(e.g., hibernate, but hey, you did not mention your application
language).
I suspect you are asking for a lazy master-child table lookup but hey,
you did not mention your tables.
This could help: http://qt-project.org/doc/qt-4.8/sql-masterdetail.html
but I recommend you getting either a better knowledge of your aim or a
good SQL/relational theory book.

Luca