S locations allowed collection table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
Table [[s_locations_allowed_collection table]] is used | 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)]]. | ||
{{DT | Currently uses "Location", this will have to move over to be controlled by [[Laptop identifier]] eventually; works for now. }} | {{DT | Currently uses "Location", this will have to move over to be controlled by [[Laptop identifier]] eventually; works for now. }} | ||
structure: | structure: | ||
* [[Service/Location]] | * '''[[Service/Location | 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. | * '''sort''' - sort order on that laptop, lowest number will be first. | ||
Revision as of 18:02, 1 March 2020
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).
|
Currently uses "Location", this will have to move over to be controlled by Laptop identifier eventually; works for now. |
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.
Related articles
| Related articles: |