Lookup table maintenance in SynWeb is made up of two reusable controls that need to be included to work properly. The two controls are:
- The dropdown and menu (seen in the image above)
- The dynamically created popup with is populated with all the fields of the relevant lookup table.
These can be included by adding the following lines to the source code of your page
<%@ Register Src="~/UserControl/UCtrlLookupTableMaintPopup.ascx" TagName="UCtrlLookupTableMaintPopup" TagPrefix="uc1" %> <%@ Register Src="~/UserControl/UCtrlLookupTableMaint.ascx" TagName="UCtrlLookupTableMaint" TagPrefix="uc2" %>
From there you can drop the "UCtrlLookupTableMaint" control where you want the drop down, you will also have to set a number of variables at this time:
<uc2:UCtrlLookupTableMaint ID="LocationLookupTableMaint" runat="server" TableName="luLocation" MaintenanceScreen="ExcursionMaintenance" PanelName="Location" />
Variables are as follows:
- TableName → The name of the lookup table you wish to maintain. e.g. luLocation, luState etc.
- MaintenanceScreen → The name of the maintenance area you are in. e.g. ExcursionMaintenance, CommunityMaintenance etc.
- PanelName → The Panel the control is on e.g. Location, Details etc.
You will also need to reference the popup control like so:
<uc1:UCtrlLookupTableMaintPopup ID="UCtrlPopupLookupTableMaint" runat="server" />