Skip to main content
Question

Show Field from Separate Table based on Corresponding Field

  • August 1, 2017
  • 0 replies
  • 32 views
I have seen a few conversations about this, but am having a hard time relating the information back to my own app.

I am looking for a way to pull a specific text field from a different table, based on corresponding text fields.

We use these apps in a production environment and have separate tables for each stage of the process. I want the current process table to show whether the job was indicated as completed at the previous process table.

Simply - I have 2 tables: Process 1 and Process 2. Both have a Job # field. Both have a Job Completed text field (Yes or No). If the Job # matches, Process 2 should automatically show a "Process 1 Job Completed" field.

Also - all data in both process tables is inputted by imports, so users are not manually typing in the Job # field for a lookup.
      This topic has been closed for replies.

      Is the Job# field unique in Table 1  ie can there be multiple table 1 records for a single job?
      Terms & ConditionsAccessibility statement