- Local time
- Today, 04:43
- Joined
- Feb 19, 2002
- Messages
- 43,346
The problem is that you are using Store rather than StoreID to make the relationships. You need to change the other two tables to have a numeric field that will be used to reference the StoreID NOT the StoreName. Relationships between tables are always on a data field in the many-side table to the primary key of the one-side table. You are trying to use a data field on the one-side table rather than its primary key. Just FYI, naming all your primary keys "ID" is poor practice and will cause nothing but confusion as you make relationships and build queries.