AndrewMoomey
7 years agoQrew Trainee
Can you embed a custom report in a form without creating a quickbase relationship between 2 tables?
I want to embed a dynamic report in one table form that selects records from another table based on the the name field in the current record, but don't want to use native "relationship" function, as it limits the related key field to one field. To further explain, one table will hold company names, while the other will hold orders. The thing is, there is the possibility of 2 company names being named on one order record. If you were to create 2 distinct relationships to the same company table, it produces two separate summary reports in the company table, one for each relationship.
What I need help with is creating a method of embedding a report on a company record that identifies the name of the company in that parent record, looks at the other orders table, and pulls out/displays a summary of order records if that company name is located in either 1 of 2 specific fields in the order record. To ensure name compliance, I ALSO would like to know if there is a way to have all the different names from the name field in the company table, to be listed as drop down options in the 2 order name fields.
(It's almost like quickbase is hiding a customize-able portion of the native relationship function, where you can further customize the report, only in the context of that 1 key field relationship. If anyone knows how to essentially combine the 2 key fields into one summary report, that may also work.)
Is this possible? Thanks!
What I need help with is creating a method of embedding a report on a company record that identifies the name of the company in that parent record, looks at the other orders table, and pulls out/displays a summary of order records if that company name is located in either 1 of 2 specific fields in the order record. To ensure name compliance, I ALSO would like to know if there is a way to have all the different names from the name field in the company table, to be listed as drop down options in the 2 order name fields.
(It's almost like quickbase is hiding a customize-able portion of the native relationship function, where you can further customize the report, only in the context of that 1 key field relationship. If anyone knows how to essentially combine the 2 key fields into one summary report, that may also work.)
Is this possible? Thanks!