Relationship between tables of two database

Hi All'

I'm in process of upgrading our Microsoft Access Database to SQL Server 2000. We have one front end database that links all the backend databases. But there are some databases which shares tables with other databases. Currently the refrential integrity is being done by VBA codes in the forms itself (bad na!).

Example
----
Database: Vehicle
Tables in "Vehicle" database are VechileType (v_type, v_desc) and VehicleInventory (v_RegNo, v_Type, customerID)

Database: Customer
Tables in "Customer" database are CustomerType(c_type, c_desc) and CustomerInventory (customerID, customerName, c_type).

This is just example...there are many (more than 10!) tables in each database. So, I do NOT want to place everything in a single database.

Now I'm looking solution for creating trigger that ensures the Refrential Integrity on "customerID" field in both VehicleInventory and CustomerInventory tables. eg user can not delete customerID from CustomerInventory table if its record exist in VehicleInventory table.

CAN ANY ONE HELP ME..................

Thanks

cheers'

-aviAvinash, why don't you create primary key and foreign key constraints to implement referential integrity. That's a better approach than triggers.

gyan.

Originally posted by avishesh
Hi All'

I'm in process of upgrading our Microsoft Access Database to SQL Server 2000. We have one front end database that links all the backend databases. But there are some databases which shares tables with other databases. Currently the refrential integrity is being done by VBA codes in the forms itself (bad na!).

Example
----
Database: Vehicle
Tables in "Vehicle" database are VechileType (v_type, v_desc) and VehicleInventory (v_RegNo, v_Type, customerID)

Database: Customer
Tables in "Customer" database are CustomerType(c_type, c_desc) and CustomerInventory (customerID, customerName, c_type).

This is just example...there are many (more than 10!) tables in each database. So, I do NOT want to place everything in a single database.

Now I'm looking solution for creating trigger that ensures the Refrential Integrity on "customerID" field in both VehicleInventory and CustomerInventory tables. eg user can not delete customerID from CustomerInventory table if its record exist in VehicleInventory table.

CAN ANY ONE HELP ME..................

Thanks

cheers'

-avi :)

Relational ACL

Hi
Does anyone have any good links on implementing a relational ACL. I can
think of some fairly obvious implementations but i'd like to know...what i
dont know.
All the links i can find are all Netware/File System relevant. Many of the
principals carry over but i'd still like further info.
For instance, SAP is obviously ACL forms but what sort of implementation do
they use? Im particularly concerned about disk space. Using the methods i
can think of : for the average number of data objects im looking at * the
number of roles that can access them, an ACL implementation would require a
disk space footprint of about 20% the size of the actual data.
That seems like a lot of bloat to me. Is this normal? I haven't yet worked
thru performance implications. The application will typically sit in shared
hosting environment so in order to keep the cost down i want to minimise the
disk space footprint while selling the highly granular security features of
ACL's to potential customers.
TIA
IanWhich one dou you mean:
http://en.wikipedia.org/wiki/ACL
:)
ML|||Thanks but ive been there. The one good link that might have been is dead.
The rest as i say is posix linux filesystem.
Guess im just going to have to learn from my mistakes on this one.
"ML" <ML@.discussions.microsoft.com> wrote in message
news:8F114745-C0BF-43FD-82DB-FCD023708799@.microsoft.com...
> Which one dou you mean:
> http://en.wikipedia.org/wiki/ACL
> :)
>
> ML