I am connecting to my own PostgreSQL server where I am setting up a Property Management database. I have an 'organization_structure' table with columns for each of the 5 possible levels within the organizations. I want to be able to add a new org element at any level (1 to 5). But I also want the user to be able to select an existing upper level. For instance, Level 1 currently has 3 entities (Scouts Canada, Ontario Incorporated Body, Quebec Property Society), Level 2 under the 'Scouts Canada' currently has 1 entity (Office of the CEO) and the other 2 Level 1 entities do not currently have any further entities specified at any other level; Level 3 currently has 2 entities under the Office of the CEO, etc., etc.
On the form, how do I configure the 'Select' components so that:
- The first 'Select' component lists the Level 1 entities (Organizations), and allows for the addition of a new entity?
- The subsequent 'Select' components list the entities filtered by the selection of the previous 'Select' components?
- Is it possible to add a new entity at any of the levels?
- Is it possible to configure the 'Select' component so that if nothing is entered in it it will put a hyphen ("-")?