S locations allowed collection table
Table s_locations_allowed_collection table is used to provide what is shown in the Service/Location field dropdown depending on the Settings (CCMBD.mdb).
Data structure:
- ServiceLocation - linked to s_dispo
- Laptop_identifier - to declare on which laptop this will shwo
- sort - sort order on that laptop, lowest number will be first.
Most of its fields are driven by dropdowns based on s_dispo table.
Removing entries
Removing entries from this table while records still exist on a laptop causes sending problems. See Service/Location field#Retiring an available Service/Location field entry.