Search results
-
A
Linking two primary keys to the same foreign key
Thanks for your reply spikepl! I do believe we have the same current solution to the problem, as a single asset table "tblAssets", with both types of assets would solve the problem. However, I was hoping i could keep a single table for each asset type. My relations would then be: 1... -
A
Linking two primary keys to the same foreign key
Hey everyone! I have an issue with building an asset tracking database. I will try to describe my situation as detailed as possible in hopes that someone can help me figure out how to solve my problems. I have two asset types, Asset1 and Asset2, which each have their own serial number mask...