Hi Ann,
Thanks a lot for your reply. I'm happy to know that I shouldn't worry too much
about the compound keys. I will look deeper into the queries.
Thanks and best regards, Steve
On Tuesday, August 11, 2015 4:09 PM, Ann Harrison aharri...@ibphoenix.com
[firebird-support]
Goodmorning,
I have to continue to work on a existing ERP program with an existing FB
database. I don't like the design very much, looks messy and the original
designer didn't think twice a lot from what I see.
Example, when I take a look at the small lookup tables used to store payment
On Aug 11, 2015, at 4:59 AM, steve.decle...@yahoo.com [firebird-support]
firebird-support@yahoogroups.com wrote:
...when I take a look at the small lookup tables used to store payment
conditions, currency codes, titles, etc, the primary key is always
VARCHAR(4) to either store a