--- In firebird-support@yahoogroups.com, "Werner F. Bruhin" <werner.bruhin@...> wrote:

>
> Hi,
>
> On 02/05/2013 10:47, dice_in_trouble wrote:
> >
> >
> >
> ...
> >
> > Thanks Nrom for the reply. I also thought of this idea, wherein I make
> > a separate table for the balance then link it up to the other 2
> > tables. But I don't know how to make table relations. I am using
> > flamerobin to build up my firebird database. Can you give me a simple
> > example of making a relationship between 3 tables?
> >
> You would use "alter table" for this, not sure how one uses this in
> flamerobin as I don't use it to generate my databases (I use
> Python/SQLAlchemy and after I designed my ORM declarative classes
> SQLAlchemy does the creation for me.
>
> Sometimes I do it manually for testing something then I use IBExpert
> (just because I new it before flamerobin), it has an option "create
> foreign key" which then walks you through the process.
>
> I am no expert but to me your question makes me think that you might
> need to read up a bit more about databases, SQL and Firebird, you should
> be able to find tutorials with a google search.
>
> Obviously the FB documentation is also not to be forgotten.
>
> http://www.firebirdsql.org/en/reference-manuals/
>
> Maybe invest in the Firebird Book, e.g. the second Edition
>
> Quote:
>
> The Firebird Book (Second Edition) is now available as a print on demand
> book (at createspace) in three parts,
>
> Volume 1: `Firebird Fundamentals
> https://www.createspace.com/4203352
>
> Volume 2: `Developing with Firebird Data
> https://www.createspace.com/4206843
>
> Volume 3: `Administering Firebird Servers and Databases
> https://www.createspace.com/4206991
>
> Regards
> Paul
>
> EndQuote
>
> Werner
>
>
> [Non-text portions of this message have been removed]
>

Thanks Paul for the advice. I have read some of the documentations on the firebird site, but I am having a hard time understanding them, and I have posted here hoping I might get some help on how to make my database as I want it.

Regards,

Cedris