How to use Tracker Field Relations

Hi,

I'm here for trackers again :)

I need to populate a field in the following way:


Assume we have

- *Customers *Table, with the list of customers;

- *Machine Types* Table, with the type of machines (Log Saw, Embosser, 
Unwinder, Rewinder)

- *Machines Sold* Table: <Customer, Machine Type, Machine Serial Number>.


So we could have for example

<Mario, LogSaw, 16125>

<Mario, Rewinder, 16826>

<Mario, LogSaw, 18152>

<Luigi, Embosser, 19642>


So when I create a new ticket, regarding a single machine belonging to a 
given customer, I'll be requested to fill:

     - *Customer* (choosen from the list) --> [Mario, Luigi], I select Mario

     - *Machine Type* (choosen from the subset composed by machine types 
the given customer owns, so I use a Dynamic Dropdown) --> [LogSaw, 
Rewinder], I select Log Saw

     - *Machine Serial Number* (automatically filled: it should be a 
dropdown automatically filled selecting the following values:
         "SELECT MachineSerialNumber FROM MachinesSold WHERE Customer = 
SelectedCustomer AND MachineType = SelectedMachineType). --> [16125, 18152]


Is there a way of achieving this, maybe by means of Relations? I've 
taken a look at this page http://doc.tiki.org/Relations-Tracker-Field 
but it is not enought for me.

Thank you in advance,

     Alessandro Martinelli

_______________________________________________
TikiWiki-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-users