Opinions on form design

[tmyers]

I see. Thank looks soo much simpler than messing with a tree view. Thanks MajP!

 

[MajP]

I see. Thank looks soo much simpler than messing with a tree view. Thanks MajP!

What you have can be shown in a traditional Form / Subform (parent / children) design. So you have multiple options to display this information. Another possible view is two linked continuous subforms.

A treeview shows it utility when you have hierarchical data with multiple levels. Especially when the amount of levels is variable and no specified limit. I would argue that is near impossible to display logically in any other way.

The Data sheet Sub Data sheet view that you are looking at works fine IMO, but others on this forum think it is too confusing. However I do think if I was using it I would put these data sheets on an unbound form. That way you have some options to put controls and nicer formatting. Also there are some hidden features of datasheets that you can use to format the datasheet better such as setting and locking column widths

You Can Do That with Datasheets?

learn.microsoft.com

Finally I think I would use it only for display and not add and delete. I do think that would be too much and get confusing.

 

[MajP]

So here is what I was saying to make this more understandable. I removed navigation buttons and ability to add records in this form. I put it on a main form for controls and formatting. I went overboard on datasheet formatting to show you can format to bring emphasis on main and sub records.

 

[tmyers]

That is pretty neat!