How to automatically Copy records from Table1 to Table2 after applying filter on Table1.
Automatically Copy records from Table1 to Table2 after applying filter on Table1. Table1 and Table2 dont have any relation.
Forum Discussion
What would you want to trigger copying records?
If this just needs to work in a single concurrent user environment, you can set up a table with a single record and have a field there to hold the Focus Article Number. Then make a relationship to the detail records based on a reference field with a formula value of 1, and then then look that up down to the detail records.
Then, make a saved table to table import subject to the filer.
Then you would make a URL formula button which would do the following steps.
Write the Article number into the Focus table for record with Record ID# of 1. (As there only is one record there)
Purge table 2
Run the saved import.
Land the user somewhere, probably on table 2.
Then, make a saved table to table import subject to the filer.
Then you would make a URL formula button which would do the following steps.
Write the Article number into the Focus table for record with Record ID# of 1. (As there only is one record there)
Purge table 2
Run the saved import.
Land the user somewhere, probably on table 2.