Database diagrams (aka Queries)
Long term MS Access user here and I'm trying to replciate our Access Database within ASP3.5 so it can be viewed over the web. However I'm having problems creating my first query!
Essentially I have two tables:
I want to display many different Models for when the user selects a Make.
I'v dragged across from MakeID in the first table, to MakeID in the second table (to create a link), but no joy whatsoever :(
This is the error message I'm getting:
14 September 200812:36:59
'Make' table saved successfully
- Unable to create relationship 'FK_Model_Make'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Model_Make". The conflict occurred in database "I:\ASP\SOLIDAUTO\APP_DATA\CATALOGUE.MDF", table "dbo.Make", column 'MakeID'.