can we navigate through Control Table cell to other related form
any suggestion
Involves some macro coding which will depend on your setup. Basically an event for the cell first grabs text value of cell you’re in, then moves the focus to the table you want, and finally possibly moves the current record in that table to a particular record based on the text. I also have a need to do something like this, but it will happen only when I find the time to mess with it. Hope that helps a little.
Hello,
The question can only be answered in general terms as each case would be specific to your data and forms.
This is done through macros. For selecting data from a grid you could do something as follows:
Sub GetGrid(oEvent)
Dim oForm As Object
Dim oColumn As Object
Dim sValue as String
Dim sFilter as String
Dim sColumnName as String
Dim iColumn as Integer
If oEvent.Buttons = 1 and oEvent.Modifiers = 2 Then
oForm = ThisComponent.Drawpage.Forms.getByName("YOUR_FORM_NAME")
iColumn = oEvent.Source.CurrentColumnPosition
oColumn = oForm.Columns.getByIndex(iColumn)
REM Data is available in oColumn.String
End If
End Sub
The above looks for the Ctrl key to be pressed with a left mouse click. This is attached to the Mouse button released event of the grid.
Once you have the desired information you can open the appropriate form and use the data in a filter to display the record(s). A sample of doing the (sample uses ID to display the record) can be found here → Base Macro - Click on Table Row to Open Record
As stated, the macros are just a generalization. They must be modified to fit your specific needs.
Added note, oColumn.Name is the name of the table column for the field selected. You can also access other pertinent data from other columns to obtain the required related data you are looking for.