I am using SQL 2000 and have two tables that I want to create a relations ship, so that when I add data to one it gets added to the other.
Table_Main
QuoteID int
PartNumber nvarchar
(both make up key field)
Table_Secondary
QuoteID int
Item nvarchar
(both make up key field)
When I use the database diagram in MS Access (ADP not MDB) I get:
"The columns in Table 'Table_Main' do not match an existing primary key or UNIQUE contraint."
Othere then then actual name of the filed, they all match, what gives?
Table_Main
QuoteID int
PartNumber nvarchar
(both make up key field)
Table_Secondary
QuoteID int
Item nvarchar
(both make up key field)
When I use the database diagram in MS Access (ADP not MDB) I get:
"The columns in Table 'Table_Main' do not match an existing primary key or UNIQUE contraint."
Othere then then actual name of the filed, they all match, what gives?