Skip to main content
Question

Pulling field from one table to another

  • March 20, 2024
  • 0 replies
  • 159 views

Forum|alt.badge.img+8

I've been trying to for days to figure this out on my own and I can't. I'm newish to writing formulas, and I'm not even sure if what I'm trying to do is best or even right.

I have Table A, Employees. I have Tables B, for tracking probationary meetings. I have the relationship set up that Table A is the parent and Table B is the child. I need to track whether the employee had a meeting and that it happened prior to the due date.

However, I can't have a lookup field from the child go to the parent. I need to bring the date from Table B to Table A so I can set up a report that will color code the record if the meeting was not done on time. I know how to do the color coding part, I just need help with getting the field from Table B to Table A. I've tried the GetFieldValues but I don't know how to point to a different table's field id. Table A emp id field is id 9. Table B related emp id is field id 15 and date is field id 28. 

Help! And thank you in advance!



------------------------------
Hannah Engelson
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

Let start with the basics.  Did you try a summary field in the relationship to detect if any children meet the criteria?  The vanilla way of getting Child information  up to the Parent is by going to the Relationship and creating a summary field.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------