Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
9 months ago

Is creating a circular relationship the only answer?

I have been doing things this way for a while.  Is there a better solution?

JOBS table related to JOB SCHEDULES table

I enter the [Start-Hang Date] on the JOB SCHEDULES table record

I want this field to show on the JOBS table record.  I have created a relationship

JOB SCHEDULES table to JOBS table to make this happen...creating a circular relationship...not ideal from what I understand.

Is there another way to accomplish this?

thank you



------------------------------
BuildPro
------------------------------

5 Replies

  • Based on the names of your tables it sounds like the proper relationship is one job has many job schedules. Why don't you just make a summary field of the minimum of the [Start-Hang Date] field and show it on your Jobs record.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain

      I'm not sure that I know how to create a summary "field". Please advise. thx



      ------------------------------
      BuildPro
      ------------------------------
      • BuildPro's avatar
        BuildPro
        Qrew Captain

        I figured out how to create summary field. thx



        ------------------------------
        BuildPro
        ------------------------------