I have a huge problem.
I need to be able to create relationship between Contact name, Position and Region for display in 4 views, one for each region. Each Position can have up to 4 names associated with it. Some other names can hold 2 or 3 Positions. Each name is associated with one region.
I need to be able to display Contact first and last name, Position and Region in a page view but be able to select the Region and the Position/s within that Region to display in a view page.
The aim is for the viewer to be able to choose which region they are in, choose the Position they need help from and see the contact details.
It seems that Drupal 6.19 can only create Select Lists from the Title field of any content type, this is a huge problem for me as it means I have to enter the first and last name 2 times, once in the title field and once in a content field. Is there a way around this?
Also I cannot create a view to use as a select list because the title only displays as a node type not a field. The Contacts drop down seems limited to 18 names and no way of displaying any more.
I have content type Contacts which contains 100 names: title [first name] Last Name field Address fields Phone fields etc.
I have Content type of Positions where title contains 40 member positions like: Web Services Administrator ISP Provider Calendar Coordinator Reviewer and so on.
I have a Region content type containing 4 Australian Regions. NA [Nothern Australia]One CA [Central Australia] SA [Southern Australia] WA [Western Australia]
I have an Admin Services content type with fields: contacts [Displays the node:title] Positions [Displays a button list of available positions] Regions [ Region sis displayed as a drop down.
I hope I've given sufficient information to obtain some help, thanks in advance. Regards Roger