Form Field filled automatically depending on selection of another field - Joomla! Forum - community, help and support

hello,

i have 3 fields on form, "project name", project number" , "report number". can 1 field filled in automatically depending on other field"

project name, drop down list of project names.

project number, unique number applied project.

report number, number of report incremented 1 each time report done.


can project number automatically filled in selection of project name? way person doesn't need remember number goes project.

also, regarding report number, if number incremented 1 automatically, end non-sequential numbers related individual projects.

example:

project 1
project name: abc
project number:123
report number:001

project 2
project name: xyz
project number:456
report number:002

project 1
project name: abc
project number:123
report number:003 <- since incremented 1, second report project #1 ends 3, not 2. imaging number have prefix of project number ...report number 123-001, 123-002, etc.

so, can project number filled in based on project name automatically, , can project number passed report number prefix , incremented 1?

this done php using fabrik...