Subject Question about Database Design, for a multi-enterprise database ( newbie )
Author joaquimmacedo
Hi all!

I'm new to Firebird and I've just downloaded Firebird 2.1.3 and installed it as Super Server on a Windows Vista computer.

I want to create a software application ( in Delphi ), using Firebird.
This application will be multi-enterprise ( ie, it can manage different enterprises ).

What I would like to ask, is - what is the best approach:
to create a database field, in all tables, that represents the Enterprise Code
OR
access different database files ( with the same tables ) - one for each Enterprise - from the software application?

Thanks a lot in advance.

Best regards,
Joaquim.