0

Protect Relationshipd (N:1)

Hi 

I have this screen withbthe WBS each level is(Relationship from Documets to each level of WBS 1,2,3,4,5. N:1) I need to protect each Level so that once definen I cannot change it again. it is posible, i

8 Antworten

null
    • Kruna
    • vor 1 Jahr
    • Gemeldet - anzeigen

    Hola Rafael,

    I created an example db, although it does not work when you chose Radio Buttons, but maybe someone else has a better solution in mind.

    There are surely many ways. Basically you can do it with help of button and a yes/no field.

    I also add an text field, so that you can try it out and also try to change radio button like eg popup, but I guess you prefer the radio buttons.

      • Rafael_Sanchis
      • vor 1 Jahr
      • Gemeldet - anzeigen

      Krunahi kruna later l try it Thanks

      • Kruna
      • vor 1 Jahr
      • Gemeldet - anzeigen

      Hola Rafael, I was thinking about the radio buttons and I may suggest that you use dynamic choice field instead. Here is an example

      • Rafael_Sanchis
      • vor 1 Jahr
      • Gemeldet - anzeigen

       neither option is feasible I need to be Relationship with each table if WBS 

      Each relation have a Trigger after option: Example Level 2

      let t := this;
      let xD := max((select Documents)['Level-1' = t.'Level-1' and 'Level-2' = t.'Level-2'].docID);
      if xD = null then docID := 1 else docID := xD + 1 end
      

      And a Consteaint

      a.'Level-1' = b.WBS_1
      

      Los niveles de WBS cambian dependiendo de los documentos asociados a los distintos niveles así como el presupuesto. el nivel 1 es el nivel del proyecto nivel 2 ejemplo Areas nivel 3 Subarea el nivel 4 los paquetes de trabajo.

      Gracias Kruna

      • Rafael_Sanchis
      • vor 1 Jahr
      • Gemeldet - anzeigen

      info 

      Breaking work into smaller tasks is a common productivity technique used to make the work more manageable and approachable. For projects, the Work Breakdown Structure (WBS) is the tool that utilizes this technique and is one of the most important project management documents. It singlehandedly integrates scope, cost and schedule baselines ensuring that project plans are in alignment.

      • Kruna
      • vor 1 Jahr
      • Gemeldet - anzeigen

      hola Rafael, I may would need your db to check out, as I am not sure, if i understand well.😅

      Actually when you chose in dynamic then its also related to the table.

      • Rafael_Sanchis
      • vor 1 Jahr
      • Gemeldet - anzeigen

        Si es complicado.

      te envío la BD es de muestra como ejemplo. 

      Si vas a la tabla Documents y en view WBS Project veras cada Documento asociado a cada nivel de WBS  cada nivel muestra el budget de cada nivel los 10 documentos tienen un budget de 75.569 €

      en cada nivel veras el budget por cada nivel. si vas de Documento por Documento ves como cambia los niveles del WBS por Documento esto se ve aquí sencillo pero puedo tener hasta 3000 o más documentos.

      Podras ver tambien las tablas de WBS son 5 tablas. 

    • Kruna
    • vor 1 Jahr
    • Gemeldet - anzeigen

    forgot to mention, you can enter same trigger in dynamic choice