Jiwa

I know how to set up a custom field as a look up field by using read data and button clicked, but is there a way to give the user the ability to clear the value back to nothing?

Have a look at the Coordinator lookup on the top right of the Service Manager screen. By right-clicking, some options are given, including one to "Clear". Below is the code used in form setup to achieve this:

Code: Select all

Private Sub SetupControls()
        Dim NewToolStripMenuItem As ToolStripMenuItem

        'Coordinator context menu
        Dim myCoordinatorContextMenuStrip As ContextMenuStrip

        myCoordinatorContextMenuStrip = New ContextMenuStrip

        NewToolStripMenuItem = New ToolStripMenuItem("Clear", Nothing, AddressOf ClearCoordinator, "Clear")
        myCoordinatorContextMenuStrip.Items.Add(NewToolStripMenuItem)

        Dim newToolStripMenuItemSeparator As New ToolStripSeparator
        myCoordinatorContextMenuStrip.Items.Add(newToolStripMenuItemSeparator)

        NewToolStripMenuItem = New ToolStripMenuItem("Set as default", Nothing, AddressOf SetCoordinatorAsDefault, "Set as default")
        myCoordinatorContextMenuStrip.Items.Add(NewToolStripMenuItem)

        NewToolStripMenuItem = New ToolStripMenuItem("Clear default", Nothing, AddressOf ClearDefaultCoordinator, "Clear default")
        myCoordinatorContextMenuStrip.Items.Add(NewToolStripMenuItem)

        CoordinatorLookup.ContextMenuStrip = myCoordinatorContextMenuStrip
End Sub

Private Sub ClearCoordinator(ByVal sender As System.Object, ByVal e As System.EventArgs)
    Job.Coordinator.Clear() 'Coordinator is a staff entity
End Sub

Private Sub SetCoordinatorAsDefault(ByVal sender As System.Object, ByVal e As System.EventArgs)
    Job.SetCoordinatorAsDefault()
End Sub

Private Sub ClearDefaultCoordinator(ByVal sender As System.Object, ByVal e As System.EventArgs)
    Job.ClearDefaultCoordinator()
End Sub


Sorry Scott,

I am a little bit lost I am referring to say a look up custom field on inventory?

My bad, I didn't read the post properly. However, the approach would be the same. Context menu on the grid with an option to "Clear" the cell clicked on (which would translate back to clearing the underlying business logic object/property). I'll see if I can slap an example together for you....

Sample plugin for 7.2.0.0 attached. Admittedly it's a bit of a production.

Thanks.