I have a database which consists of 8 tables. They are all interlinked and there are, I believe, three many-to-many relationships among these. In the Form Designer, according to the documentation, links established in the database automatically port over into the Data Environment. However, when I create a new Form, and go into the Data Environment - the links are not accurate. Or rather, several of them are missing. They seem to be related to the many-to-many relationships - i.e. the second link is missing.

Example - in a book inventory database, I will have the Books table linked to the Authors table (many-to-many) via a Books/Authors junction table. In the Form Designer Data Environment, it acknowledges a link between the Books table and the Books/Authors table. But there is no link whatsoever between the Books/Authors table and the Authors table. The missing links are always the latter connection of a many-to-many relationship.

I see three possibilities:

1. This is how it shows it, but it offers no functional problems.
2. There are functional limitations, and I can do something about it.
3. There are functional limitations, and I can't do anything about it.

Help? :)

Daniel