Branch relationships between primary and foreign ID

[neuk]

Imagine I have a basic primary id item (widget(n)) and foreign id item (object(n)) relationship. On a continuous form it would look something like this:

Widget 1	Object 1
Widget 1	Object 2
Widget 1	Object 3
Widget 2	Object 4
Widget 2	Object 5
Widget 3	Object 6
Widget 3	Object 7
Widget 3	Object 8
Widget 3	Object 9

While that makes perfect sense, it would be nice if I could display the relationship like such on a form:

Widget 1	Object 1
	Object 2
	Object 3
Widget 2	Object 4
	Object 5
Widget 3	Object 6
	Object 7
	Object 8
	Object 9

In other words, instead of “visually” repeating the primary id item – although that’s the whole point – can you display it such that it shows the primary id item only once and then lists all relationships underneath? I don't need to edit or change anything on this form. I'd just like it for a visual reference to what's going on other forms where I make these connections.

[ranman256]

a report can, but not really in a form.
Forms are all , or nothing.

[neuk]

I'm not too familiar with reports, but I think a report would work since what I'm trying to do is only for reference purposes - not trying to edit or change anything. Do you know what this sort of thing I'm trying to do is called so I can google it or do you know a reference off hand where someone shows this specific thing I'm trying to do?

[Welshgasman]

PMFJI,
Hide Duplicates

[neuk]

Ok. Thank you. I think this link will help anyone interested:

[Micron]

I'm not sure I see the sense in that unless perhaps it has something to do with the appearance of the report, or perhaps when that was posted, reports didn't have grouping capability. Somehow I think that's not the case though. So why not just create a 'Group by' Widget on the report? In design, right click on report and choose 'Sorting and grouping' from the context menu...

[neuk]

I'm not sure I see the sense in that unless perhaps it has something to do with the appearance of the report, or perhaps when that was posted, reports didn't have grouping capability. Somehow I think that's not the case though. So why not just create a 'Group by' Widget on the report? In design, right click on report and choose 'Sorting and grouping' from the context menu...

Micron,
You're right. I deleted that reference. Simply grouping by specific fields that apply to the primary id worked.

[Micron]

Deleting the link kind breaks the continuity IMO. Besides, if you left it in, it might do 2 things
- direct someone to a method that is appropriate for their situation
- introduce them to one of the best Access info sites there is