Is creating a circular relationship the only answer?

Question

I have been doing things this way for a while.&nbsp; 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.&nbsp; 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------------------------------

markshnier__you · Answer

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

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

buildpro · Answer

I figured out how to create summary field. thx------------------------------BuildPro------------------------------

markshnier__you · Answer

np,&nbsp; Just got to the Relationship where 1 Job has many Job Schedules and use the button there on the left side of the relationship to create a Summary field.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

buildpro · Answer

Worked great!&nbsp; Thank you------------------------------BuildPro------------------------------

Forum Discussion

Is creating a circular relationship the only answer?

5 Replies