Topic: Output of the table to the form
The table "Elements" is created. In the table elements with characteristics are set. If the element is the subordinate on other element the parent is underlined.
In a screenshot at the left it is table Access. Such table is difficult for reading and adjusting. Therefore it is necessary to deduce this the table on the form so that was in the form of a tree. The screenshot on the right see.
1. Prompt as it it is possible to make in Access?
2. If the table is enough to have the characteristic "Parent" as foreign key or still that that it is necessary?
Pay attention "the element Code" (not "Code") is text as between digits the point is ("3.1", "3.1.1").