Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

Very confusing issue

Here it goes. Trying to figure out why one table relationship works one way for a report link and another another table relationship doesn't. Tables we will look at:  JOBS, SUB PAYROLL, ORDERS.  Background info:

1.  Using COPY JOB button.  This was created many many years ago.  I have no memory of where I got it.  I am attaching a document because when I try to paste here, I get kicked out.

2.  JOBS to SUB PAYROLL -

3.  SUB PAYROLL to JOBS -
RESULT:  NEW JOB NUMBERS (after copied from "template) "connect" automatically and shows this report on the JOBS form  -

NOW for ORDERS -
JOBS to ORDERS -

ORDERS to JOBS -
RESULT:  NEW JOB NUMBERS (after copied from "template) "DO NOT connect" automatically and shows this report on the JOBS form  -


------------------------------
BuildPro
------------------------------
App builders
  • BuildPro's avatar
    BuildPro
    Qrew Captain
    3 years ago
    In essence....I am trying to figure out how a new job (from copied template) automatically appears in SUB PAYROLL, but not in ORDERS?

    ------------------------------
    BuildPro
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      Although you posted the JavaScript code, that is simply calling a code page. Typically you need a real developer to make changes to a code page. I suppose you could post the code page but it's probably unlikely that anyone on this forum will assist.  You will probably have to contract with a Quickbase solution provider to get help.

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • BuildPro's avatar
        BuildPro
        Qrew Captain
        3 years ago
        Thanks, Mark.
        This actual coincides with our previous discussion.  Do you think this code has something to do with the reason that JOBS seem to connect automatically with SUB PAYROLL, but not ORDERS?  I can't seem to identify the field that "adds" the job to SUB PAYROLL automatically.  I have to manually click "add order" to "connect" to JOBS

        Also, there is no RECORD# field in JOBS.  Only a TASK ID# (key field).
        The KEY FIELDs in both SUB PAYROLL and ORDERS is the RECORD ID#

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