# can we navigate through Control Table cell linked to other related form

can we navigate through Control Table cell to other related form

any suggestion

edit retag close merge delete

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.

( 2018-10-17 09:05:46 +0200 )edit

Sort by » oldest newest most voted

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.

more

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.