Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mattsmith321
Starting Member
12 Posts |
 Posted - 2001-07-28 : 23:33:21
|
| Here is the problem I am facing:I have three tables that contain similar items but there is enough difference to warrant separate tables. Let's call the tables Cars, Trucks, and Motorcycles. Then, I have another table for Users and there is a VehicleID field which would reference a specific vehicle in either the Cars, Trucks, or Motorcycles table. How do I deal with all of the complexities surrounding this situation. I could add a VehicleType field to Users but then what?I am posting this question right now while I am just getting started doing my research. If anyone knows of a link (article/forum topic/whatever) that would help, I would appreciate it. I can't exactly think of any good keywords to search for so I will be out trolling throught the site and forum for a while.Thanks,Matt |
|
|
|
|
|
Help with Field referencing different tables