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]