Hi All,

I'm wanting to create multiple data bases in order to cut down on redundant data.

For example, I have a Lookup database that has various tables that use an auto-incremented Ident PK. I want to use this PK as an FK in other databases.

How would I tie this together to ensure data integrity?

How would I use llbl to use this information as though it was just one database?

Can this be done?

Thanks,

Fishy

My novice SQL answer to ensure ref. integrity on MS SQL SERVER would require writing triggers to make sure that the FK field was a valid record in the other db.

Tying them together virtually however is beautifully simply. In the LLBL UI, with both db's added as catalogs, go to the entity -> relations -> right click -> add new X.

Thanks