Summary Field Problems
I am trying to pull a series of dates from a child table. I believe that my problem is coming from the fact that the child table is also connected table. I've screenshotted the three attachments. ...
Forum Discussion
I'm trying to pull maximum Keel Date , launch date, USCG COI Date, and Delivery date from the hull table.
The two relationships that are important here is the Orders and Hull. I've screenshotted the relationship between the two. Orders has many hulls. Both tables are connected tables and are pulling data from another application. I believe that is where my problem lies since the key field is Record ID# 2. Therefore, the relationship between Order and Hull has a key field Record ID# 2 instead of Record ID#. This is the record ID from the second application (connected app)
------------------------------
Sarah Burres
------------------------------
The two relationships that are important here is the Orders and Hull. I've screenshotted the relationship between the two. Orders has many hulls. Both tables are connected tables and are pulling data from another application. I believe that is where my problem lies since the key field is Record ID# 2. Therefore, the relationship between Order and Hull has a key field Record ID# 2 instead of Record ID#. This is the record ID from the second application (connected app)
------------------------------
Sarah Burres
------------------------------
Are you getting an error? What is the problem that you're seeing? From your screenshots, everything looks right to me.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- I’m not getting any date. It’s a summary field.
- Ok, in the relationship, is the [Related Order] field from the original table that you're syncing from or was it created when you built the new relationship? In order to pull the data correctly, it would need to be from the original table.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------- MarkShnier__You
Qrew Legend
Sara,
I gather that both the parent and child table are connect Sync tables. The [Record ID#2] sound correct for the Key field of orders since it is a connected Sync Table.
When you built the relationship to he also connected Hulls table, so you use the same field that was used in the real relationship? is the field [Related Order] a connected field? Does it have values in it?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
