I'm converting a MySQL web app to Firebird 1.5 and have been reading
about Referential integrity constraints in the manual(DataDef) and was
wondering how do you decide which table is the one with the Foreign
Key? Is also appears that since there is no Auto Incriment and one
must generate an ID first when used in multiple tables to insure
integrity, that there is not a lot of reason to set it up to start
with. OR, is handling multiple table updates handled differently in
FB? The reason I ask is that the MySQL application I am trying to
convert has a lot of "FOREIGN KEY (Coupon) REFERENCES coupon (ID)"
constraints so I need to understand this well before I continue. I
come from the MSSQL world so am not that familiar with MySLQ or FB so
this is a little puzzling. If anyone ever writes a book on FB, I hope
they put in a 1000 examples as that seem to be what is lacking the
most, and this applies to most docs no matter what db one talks about!