1. Recordset Data Scrub (32:08)
Making Data Relational
Keep Existing Data
Put Sample Data in BoxT
Create ContainerT: ContainerID, ContainerName
Create PositionT: PositionID, ContainerID, Volume
Create Transfer Routine
Get ID of Newly Added Record
2. Nested Continuous Forms (19:11)
ContainerF, PositionF
Continuous Form inside a Continuous Form
Recreate Add Box Code
Composite Key ContainerID, PositionName
3. Side By Side Subforms (13:13)
Side by Side Continuous Subforms
OnCurrent Event Change RecordSource
Change Subform SourceObject
4. Arrays (17:20)
Dim Static Array
Load Manually
Load with Recordset Data
Dynamic Size Array
Redim Preserve
Ubound, Lbound
5. Parent Breadcrumbs (27:31)
Load Array with Parents
Load Parents into Listbox
For Next Step