Relationship Problems

[matt d]

Okay, I am stumped... This is an involved question, so hopfully I can ask the question is just one post.

So, I have created a database solution for keeping track of people, their vehicles, addresses, etc... I have a table called "Participants." This table contains basic information on people. All other tables are prtty much related to the participant's record ID number.

One of those related tables is a table called "vehicles_participant_relations." This is a table to link a participant with a vehicle within the "vehicles" tables.

Here is a diagram of how the tables are related:

So, in a layout when I click on my "participant" and then the sub-form of "vehicles" I can assign vehicles (where exist in the "vehicles" table) to that person. Here is an example:

It works very well. But there is one problem. When I am working with the "vehicles" table directly, I wanted to put a protal that showed all of its associates with participants. So, I created a portal row under the "vehicles_participant_relationships" table. I drew some fields, which it recognized as being related, but when I browse the form the table is empty? Here is what it shows:

The relationship obvously works correctly because under the participants form, it shows the associations just fine.

Does anyone know why it is not working and how to fix the problem?

Thank you!

[MoonShadow]

When I am working with the "vehicles" table directly, I wanted to put a protal that showed all of its associates with participants.

Do you see where Vehicles flows into vehicles_participant_relations? The end is a flat line (where it enters the 'box'). I believe this indicates that your Vehicle ID in your vehicles_participant _relations table is not indexable (possibly a global).

So when pulling data into your Vehicles table, that (possible) global is on your related (many side). If so, it can't provide data to your portal. You might check the field type there. Otherwise, it looks like it should work.

The relationship obvously works correctly because under the participants form, it shows the associations just fine.

Yep, flowing the other direction. A relationship can work fine flowing one direction but be stopped the other - at that flatline point.