Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years 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...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

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
3 years ago

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



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