0

Conceptual Problem.

Conceptual Doubt about the Disciplines and Activities Tables The Disciplines table has some specialties, example Civil has Foundations etc as a specialty and each specialty has different activities, Now I have Disciplines and Activities as separate tables related Disciplines to Activities 1 to N, I need to take the Activities of the specialties table civil, I need a table that relates Disciplines - Specialties - Activities? or create Civil-Specialties subtables I'm confused here.

6 replies

null
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    Ready

    • Fred
    • 2 yrs ago
    • Reported - view

    If you don't mind telling us what you ended doing and how it is working for you.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    😂Fred 

    Now my Data Model  Disciplinas now have a Subtable call Especialist link with Activities.

    Example Civil have some Especialist how Fundación, Estructure, etc each Disciplines have 5 or 6 Especialist.

    For now work for me, I don't know if there other best solution.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    My Form Display, Disciplines with Especialist. And I have a switch to display or not,  I don't need view all the time only for setup 

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

       Fred

      Nice now look better. Disciplinas / Especialidades / Actividades.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    Fred @

    I Will try to explain as Best as posible I hope.

    In the form you see the Avance Plan and Avance Real the two field change every friday when I change the FechaCorte I need to place these value on other field  if I have 18 weeks project need 18 field for store theses field, but May have project for 2 years😣 and more than 1500 or 2000 documents.

    Now I do manually in the Table Avances 

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 6Replies
  • 70Views
  • 2 Following