Database Diagram - Relationships

[pachjo]

Here is the layout of two tables I have:

TransactionDescriptions

DescriptionID (Primary)
Description (Primary)
Void

Transactions

TransactionID (Primary)
TransactionDate (Primary)
DescriptionID
Amount
RollingBalance
Void

No my code will not give access through the front end the possibility of deleting transaction descriptions, only voiding them.

But following the Absolute Beginner's Series VB Lesson 8 video I thought I would setup a relationship so that a foreign key constraint would stop it from happening regardless.

I have opened the Database Diagram window and I drag DescriptionID from the TransactionDescriptions table to the Transactions table but get an error saying the both sides should have same number of rows?

I get this if I drag the other way to?

Yoinks......help?

 

[pachjo]

Too long working in QA forgot the stuff learned in Access re.......indexes!

When into section to manage indexes and keys, first time for in in VB.NET