The application that we are working on, will be used to track all the variables that go into make a batch of compost (we are a mushroom grower).
Application flow explanation:
3 - Areas of data collection
Phase 1 Composting
Phase 2 Composting
House Information
In the "View Complete House Record" (HTML View) All the data needs to be display as it relates to the "house number" that is selected.
Example of the most complicated situation:
(2) - Phase 1 batches per Phase 2 Batch
(3) - Phase 2 batch per house
Example:
[House #21] contains the following records
[P2 batch A] = [P1 batch 1] & [P1 batch 2]
[P2 batch B] = [P1 batch 3] & [P1 batch 4]
[P2 batch C] = [P1 batch 5] & [P1 batch 6]
Flow of form completion:
Phase 1 fills out a new batch
Phase 2 fills out a new batch and identifies the phase 1 batch(s) [this ties the phase 1 batch to the phase 2 batch]
House Information is filled out- user identifies the Phase 2 batch(s) - [this ties the phase 2 batch(s) with the respective phase 1 batch(s) to the house record]
Note that a new record is filled out each day for each section (Phase 1 / Phase 2 / House)
I need to know how to pass the various phase 1 & 2 batch numbers based on the related phase 2 batch number & house number, so that when I create a custom function in to be used on the House form's list view, it will open a single HTML page that will display all the possible Phase 1 & Phase 2 records relevant to the specific house number.