Relationship Design Tool - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Relationship Design Tool

David Cummins

2 years ago

I am relating tables via PK's and FK's via Combo Boxes and Queries. I don't see any of these relationships displayed when I look at the Relationship Design tab. Is this a useful tool or should I ignore it?

	David Burns @Reply 2 years ago
Does Access recognise that the tables are linked by just typing in the FKs?

	Alex Hedley @Reply 2 years ago
Have you named the Fields the same?

David Cummins OP @Reply

2 years ago

David Burns, Access does not show any linked tables. I am not sure what typing in the FK's mean. I don't see a place to type them in.

Alex, the field names are the same.

In any case, my app is working so, I am ignoring the Relationship Design tool. I am using Dataverse as the data tables until I can migrate to Zoho. Dataverse renders Relationship Design tool irrelevant function, which is a bit confusing given that Access is supposed to integrate with Dataverse. As I stated in other posts, Dataverse is shaky data source for Access.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View