I am implementing a ticket tracking system for one of my customers that tracks hardware repair issues. We have a department, a contact for the department and a piece of hardware that belongs to the department. All three fields are autocomplete noderef fields.
What we would like to be able to do is filter the contact list and the hardware list on the node create/edit form when a department is selected. It looks like using the "Advanced-nodes that can be referenced" option is the way to go, but I can't figure out how to get the value of the department field passed to the view. I have read numerous threads on passing arguments, but it looks like passing the value of a form field as an argument may not be possible, or I am dense and just can't make it work.
Can I do this with the Advanced option or is this something that will require some custom coding/AJAXy goodness? Is there a module that provides this or similar functionality?
Thanks for your help