Thanks for your Reply.
I have FORM with fields in the Form:
START DATE (DATE)
OFICINA( This is a multiselect from TABLE OFICINA)
ZONE (DROPDOWN FROM TABLE ZONE)
AREA (DROPDOWNFROM TABLE AREA )
PROYECT(DROPDOWN FROM TABLE PROYECT)
CLIENT (DROPDOWN FROM TABLE CLIENT CLIENT )
OBSERVACION (TEXT FIELD)
ORDER_BY(EMAIL OF THE PERSON CREATING- INSERT AUTO).
Now the objective is:
USER CAN SELECT from multiselect FIELD OFICINA x No of OFICINA (eg. VALENCIA, MADRID, BARCELONA)
and fill rest of the Fields.
ON CREATE, POPULATE new ROWS in TABLE SUBPROYECTOS depending on the no of values selected in OFICINA.
REPETE all the Values in Rows expect the field OFICINA which will change on multiselect values.
Hopefuly I was able to explain properly.