Skip to main content
Question

Is creating a circular relationship the only answer?

  • August 21, 2023
  • 0 replies
  • 44 views
Forum|alt.badge.img+11

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
------------------------------

    MarkShnierYou
    Forum|alt.badge.img+22

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement