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:

Make_Table
MakeID
Make

Model_Table
ModelID
MakeID
Model

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
   User:
   Server: .\SQLEXPRESS
   Database:
   Application:
*/

'Make' table saved successfully
'Model' table
- 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'.

Managed to suss this! Basically, what it was saying was I had a value in one table that was trying to call information up in another...that wasn't there.

So a value in 'Model' was trying to call up 'MakeID=1' but that wasn't there.