-- Enforce Integrity ----
I have probably structured this wrong so any advice critical or not is fine :)
I have an application whichs tracks assets (computers)
In my parts_master table I record the current_location and would like to force integrity with two master location tables
eg the asset can either within our own branch network or in a 3rd parties branch network and therefor have two tables holding the branches details (structured different as need to hold different data) How can I enforce that the current_location in parts_master is in either one of our brances or one of the thirdparty branches. Sorry thats really confusing....
InternalSites (PK BranchID)
Parts_Master (BranchID) enforce from either table above - the ranges of branch numers between tables is easily distinguisable.
I'm sure there's a better way to structure this.
Thanks for your time