Hi all,
First, i'd like to Tanks everybody that helped me with my IR printer and currencies
stuff.
The new question is:
While reading the Sachin Pawaskar email, about number of databases, I realize that i'm
using the same
RDBMS structure, using 4 tables relationed with primary and foreign keys.
But, sometimes, i will have to list information with records from 2 tables at the same
time. Its possible? Its the right approach to palm devices?
Example:
I have a Product linked to an Item database (1->N)
an Order linked to the same Item Database (1->N)
a Client linked to Order Database (1->N)
the primary key from the Item DB are the Foreigners keys from Product and Order.
Its possible to show in a list (or table), lines like this? (ordered by Name)
NumberItems (from Item) , Name (from Product), Total (from Item)
This information have been already filtered by ClientID (from Client) and OrderID
(from Order).
Thanx in advance,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~ Luiz Paulo Gama Barreto ~~~~~~
~~~ Computer Engineering, UFES ~~~
~~~~~~~~~ Vitoria - ES - Brazil ~~~~~~~~~
~~~ mailto:[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
