I have filtered my data. How to export the filter-result to calc?
Data Source as Table tool in
Form Navigation toolbar: this opens a pane that displays the table data.
Click at the intersection of the row and column headers to select all records. Keep the left click and drag-and-drop in Calc.
“Keep the left click and drag-and-drop in Calc” works! But the result does not look the same, see screenshot → Dropbox - File Deleted
Bauart_fk in base shows the name, in calc it shows the foreign key number.
@cool Does the data come from a subform?
Yes, from other table.
You’re grabbing and dropping a Form’s
Table Control. Try grabbing and dropping a Query (from the icon to the left of the name of the query). I think this will give you what you want.
You will have to build your query to show the looked up values, not the keys (i.e. relate the tables in the query).
Hi, I use a form-based filter, not a query.