MLM binary plan

[DARTHSTRIDER]

Good day! can somebody help me how to make an mlm binary plan for my school project.

premise:

- each members must have two (left and right) sponsored members.


- must generate a report having their hierarchy.
- i already made a form and when i generate report, it only report its sponsor in alphabetical order and not in hierarchy.



hope somebody can help me. thanks!

[June7]

Never heard of 'mlm binary plan'. But looks like something Visio would be suited for.

What values is the alphabetic sort based on? A text description? Need a field with a value that can be used to sort by levels. Could be a number field and assign number to each level. This could be a field in table or could be a field constructed by expression in a query.

Getting the members at same heirarchy to disply side-by-side will not be easy.