ContributionsMost RecentMost LikesSolutionsRe: Button to open form (on child table) from report (on parent table)Wow....this was so easy and works so well. Thank you!Button to open form (on child table) from report (on parent table)Hello, Hope you can help with this. I found a few related articles but can't seem to make the formula work. I have two tables: Transactions (parent) and Notes (child). There is one note to one transaction. I have a report on the parent table that lists transactions and I'd like to create a formula URL button on that report that opens the related note (using a designated form, "view" mode). What would be the formula for this? Thank you!Re: Connected tables: Is it possible to set up a connection with 20 tables channeling data into one connected table?Thank you for your help and responses! I decided to manually transfer all records and attachments to one table and then set up the necessary reporting that way. It's cleaner this way and I'm using native Quick Base functionality. It would be nice if Quick Base added the report option to search <some attached file> and <some field> at the same time, from one string of text entered by the user (one search bar).Re: Connected tables: Is it possible to set up a connection with 20 tables channeling data into one connected table?OK, I appreciate your help. One last attempt: if I were to set up 20 relationships, a "Keywords" lookup field for each relationship (words separated by commas, or just words without commas), and run a report on the keywords. Do you have recommendations on how to make the search more effective? So that a person looking for a document can type in a chain of words and actually get a few relevant results?Re: Connected tables: Is it possible to set up a connection with 20 tables channeling data into one connected table?Sorry for the confusion. Yes, I am trying to search the content of the file attachments. Is there a native-to-Quick-Base way of gathering all the file attachments on one table, a table that updates automatically, to achieve that? In response to the <iframes>s, I can't quite picture how the report would work. When you say "individual file content search results," are you imagining one search bar at the top of the hosted page that would then show the results below as a single report (even though they are 20 individual <iframe>s)? And how labor intensive would it be to set this up?Re: Connected tables: Is it possible to set up a connection with 20 tables channeling data into one connected table?But the file attachment (the content within the file attachment) will not be searchable on the centralized table.Re: Connected tables: Is it possible to set up a connection with 20 tables channeling data into one connected table?I appreciate the idea. But it seems that now we are straying away from the main goal. Originally, I wanted to gather records from all 20 tables into one centralized table with the goal of running a report using the filter"<some attached file> contains the word <ask the user>." But with your idea I would have a field of links, not file attachments. These would not be searchable. Do you know of a way to go around this?Re: Connected tables: Is it possible to set up a connection with 20 tables channeling data into one connected table?Thank you for the response! I'm not sure Quick Base Actions are the best solution because we need to not just add records to the centralized table but also modify/delete them when the corresponding record in one of the 20 tables is modified/deleted. Is it possible to do this with a QuickBase Action? And for the "formula to link back to the original document," what formula would you use?Connected tables: Is it possible to set up a connection with 20 tables channeling data into one connected table?Hello, I am working with a document library. There are 20 tables, and different users have permission to access different tables. All records have file attachments. I would like to set up a connected table so that all records from the 20 tables sync into one large table. Is that possible? (A table-to-table import wouldn't be able to import the file attachments so the connected table seems like the best option.) The end goal would then be to create a report that searched the file attachment field using "contains the value <ask the user>" filter. Any advice? Thank you.Re: How to extract month and year from date, then use them in a relationshipThank you so much! It works!