Is there a recipe or some other quick / dirty way to accomplish the following task:
Sample Case for illustration
Table 1: CarMakeModel
Table 2: CarOwners (M:1)
Table 3: CarWidgets (M:1) (etc..)
I want to be able to create a summary page where, after selecting from a list of car makes and models you are then taken to a summary page that includes
Car Make / Model details followed by
Listing of all Car Owners and Details (up to x number of rows / with vertical scrolling bars if possible) followed by
Listing of all Car Widgets and Details (up to x number of rows / with vertical scrolling bars if possible)
All on the same page
The problem I'm having is that the query to get the listing of all Car Owners is
Select * from CarOwners where CarOwner.MakeModel_ID = CarMakeModel.ID and CarMakeModel.ID = {selected id from the list};
which isn't an available option from the Record Type > Views and Headers > Generate Record View since the relationship is on the CarOwners, not CarMakeModel.
Yet the principle selection criteria is from the listing of all CarMakeModel(s)
Is there a sample somewhere of something similar that someone could point me to on how to do this?
Discussion posts and replies are publicly visible
You essentially need to follow this pattern:
You'll need 3 queries to this. Basically, you list the cars, save the id of the make/model in a local variable and query the 2 other Record Types with that variable and display the results/details under the grid.
Not sure if its doable via the generate view.
If you already have the record relationships established, then while generating the views, you will automatically have these fields available for you on the summary page. You can use grids to show 1:M type relationships.