Added drop down dialog list box for patrol name with view lookup special dbcolumn formula on scout info doc to create additional scout docs using the existing patrol names. Therefore the patrol name needs only be typed in once then it can be used for all new entries.Can also be used for team name.



Special dbcolumn formula using a hidden "Scout By Patrol" view column 1 data to populate a Dialog List Box !!

@If(!@IsNewDoc & @IsDocBeingLoaded; @Unavailable; @DbColumn("":"NoCache"; ""; "(Scout By Patrol)"; 1))



This Scout Roster Database meets the requirement for Scouting's computer merit badge 4a. >> http://www.meritbadge.com/mb/036.htm