ContributionsMost RecentMost LikesSolutionsRe: Need to have multiple many to many join tables in order to report related dataChild's table called multiple locations. So I have Multiple Locations records that I have created a report link to documents using the related work order ID# then get back the related documents for that multiple locations' record. Re: Need to have multiple many to many join tables in order to report related dataOkay, my friend, now my head hurts! lol I've tried using report links to walk up the relationship ladder but to no avail. Overall in this application, we are keeping track and documenting many projects each year (15 to 20). Each project may have multiple Work Orders (some with 5 to 10). Each Work Order may involve a number of assets that are being worked at one time (we are maintaining 16 parking garages and 189 parking lots) (i.e. we may have a resurfacing project for 3 parking lots going into on Work Order. And each Work Order will have multiple documents like contracts, invoices, inspections and even construction plans. Almost 100% of these documents have an attachment (usually signed scanned PDFs) The ultimate goal is to look at each Project, Asset (garage or surface lot) and Vendor and see a complete history and data as well as status of each. Projects need to show Work Orders, Assets and Related Documents Assets need to show Projects, Work Orders and Related Documents Vendors need to show Projects, Work Orders and Related Documents If I have Work Order ID#1 with work being done in Garage Able ID#101 and Garage Baker ID#102. The Work Order itself is a large record with all kinds of fields documenting the Related Vendor, details of work to be done and the $ amounts to be spent, and the Related Project. Then we create various documents from the Work Order such as Work Contract DocID#300, Invoice DocID#301 and Work Completion inspection Doc ID#302. It would be great to pull up Garage Able and see the history of Projects with related work orders that had Able as one of the assets in that work order as well as all the documents created from that work order, all on the same screen. Of course, the same info would show up on the Garage Baker screen as it relates to Work Order ID#1. It would be great to have the ability to create a multiple key report link. Like, from Assets to Documents send back all documents related to Work Order ID#1 and Garage ID#??? (Garage Able ID#101) thus showing Document ID#300, #301 and #302. The same report would show for Garage Baker ID#102. Does that make sense? Re: Need to have multiple many to many join tables in order to report related dataI knew this about Report Links but for a different issue. I'm going to see if I can put this into action with one of my more complicated situations. Thanks!Need to have multiple many to many join tables in order to report related dataTables: Parking facilities; Annual Projects; Work Orders; Documents (there are more but will stick with these for this post) Relationships: Parking facilities- many Projects, - many Work Orders - many Documents Projects - many facilities - many work orders - many documents Work Orders - one Project - many facilities - many documents So, we create our Projects for the year then begin our Work Orders for the Project. The Work Order record will show the related Project then select (add) each facility to be worked on through a connection many-to-many table. Also within the Work Order we add documents for items like vendor contracts outlining the statement of work and the vendor invoices for the work completed. It is very important that each Project record show the historical work orders and documents; each facility record show the historical list of Projects, related Work Orders and related documents. I have been able to accomplish the historical work order report under Project records and Facility records but have no idea how to show that list of related documents (under the work order) for each of the related facilities to the work order. Example: I have Project A for 2018. Project A has two work orders: W.O.#1 and W.O.#2. W.O.#1 is covering Garage Able, Garage Baker & Garage Charlie W.O.#1 also has document record Contract #100 & document record Invoice #200 W.O.#2 is covering Garage Able & Garage Zebra W.O.#2 has document record As Built plans #300 & document record Invoice #201 I need to be able to see under the record for Garage Able: Project A for 2018 in the list of current and past project Work Orders #1 and #2 in the list of current and past work orders Documents #100, #200, #300 and #201 in the list of related documents (of course a document description in the list) Of course each list item under a project or facility must be easily identified and be linked to the under lying record to obtain more detail. I'm thinking this can be accomplished with some report links but I cannot figure how to have it work closer to a many to many to many relationship.Re: I need to sort text numbers in a table report with records with Article and Section numbersHold on....I think I came up with a solution... Instead of 3.1, 3.2, 3.3 ......3.9, 3.10 I put a zero in front of single numbers after the decimal: 3.01, 3.02, 3.03 .......3.09, 3.10 It worked. Just won't correspondexactly with the numbers in the print document.I need to sort text numbers in a table report with records with Article and Section numbersI need to sort text numbers in a table report with records from a 800 page agreement with Article numbers 1 - 20 and Section numbers that go up to x.21. So when I have Article 3 Section 3.13, I want it to be after 3.12 not before 3.20Re: How do you create the relationship back to a Parent table record from ""Orphan"" child recordsYep. Thanks anyway.Re: How do you create the relationship back to a Parent table record from ""Orphan"" child recordsHmmm....that sounds like a huge undertaking but I do need to have that relationship. Since both tables have the Parking Lot Number isn't there a way I can maybe place in the Parking Lot table a formula field that says if the record has Parking Lot Number 1234 then [Record ID#]? Then someway in the Catch Basin table have the same Parking Lot Number 123 translate to that [Record ID#] and use it to relate the records? Hope that makes sense. I'm having a lot of trouble with relationships in this huge application and have placed a number of postings with no good results yet. This one is only one of the recent issues but also one the simpler. The other problems involve multi level relationships where I need to relate records back up about 3 to 4 generations. But that is for another day.How do you create the relationship back to a Parent table record from ""Orphan"" child recordsI have a table with Parking Lots and a new child table with drainage catch basins within those Lots. Each lot has a unique number that is not the record ID# (key field) and I cannot, for a number of reasons, make that Lot Number the key field. Anyway, all of the catch basin records are a csv file import and the Lot Number is part of those records. Using a report link works to show the catch basins under each parking lot, but I need to create a Related Lot numeric reference (the Lot's record ID#) for each of the catch basin records. There are 189 lots and 305 catch basins so I need a way to get this done by formula or something.Master Table Record ID passing to a Grandchild Table Record through the Child Table RecordI have Projects that can create Work Orders directly but also have an intermediate table that creates records sometimes from Projects called Work Projects that I also create Work Orders. I need to have the Work Orders records added from Work Projects capture the Project relationship from the Work Project. I can pass to the Work Order form the Work Projects - Project_Name (text proxy) but that does not create the relationship field value for Work Orders - Project_Name. I need this same solution for a number of table record combinations. I really need to do this with the inherent capabilities of Quick Base. I've tried setting up a many to many but can't figure out how to accomplish this with so many tables and records in this app.