Base Freezing and won't allow set relationship

[ocgirl]

Base 7.3.7.2 froze when I was troubleshooting a query. I was attempting to use the forward arrow key to move thru each record in the edit mode. Also, I was attempting to set a new relationship between two tables. Each time I selected the field in the main table it says that the relationship was already set. When I open the edit box it shows a different field related to a different table. When the program froze, I used End Task. Then, I shut down the computer and restarted. It’s no longer frozen, but it still will not allow me to set new relationship even in the edit table. I am trying to set a relationship for “Seed Certified Organic?” from the “Seed Name Master Table” to the "Vendor Seed Price Table. " See screen shot of Edit which shows different Tables and different relationship

Edit: One of the screenshots was wrong. I

[RobertG]

You have just connected “Vendors Seed Price Table” with “Seed Name Master Table”.
Every connection you will draw in the relationships needs a primary key or a unique field. But you are trying to connect fields, which aren’t unique in one of the table and aren’t primary keys.

[robleyd]

I suggest that before you get any further down that particular rabbit hole that you review your database table design with consideration to normalising your data and increasing data integrity. In very simple terms that means designing your data structure to avoid duplication of data - as in your seed price and seed name tables for example.

I’d also suggest you name your tables and fields using the KIS principle, avoid spaces (use underscores) and unnecessary characters like ! and ?

A few resources that may be worth a read to get the idea of normalisation - https://www.w3schools.in/DBMS/database-normalization/ and Database normalization - Wikipedia. The Sheepdog guides might also be handy.