I should be more clear; I feel a bit crazy because this shouldn't be so difficult. Maybe my brain is broken at the moment.
Cycle 1 has 100 Cycle Records. Cycle 2 has 100 Cycle Records.
When I hit a button in Cycle 1, I want only the 100 Cycle Records from Cycle 1 to record.
For the filter, I can only choose from the Cycle Records table. So what I really need is a way to pass the filter which Cycle I am clicking from.
If I try to set up a filter checking against "Related Cycle" I can choose "equal to a value in a field", but I have to select fields still from Cycle Records. Or I can choose "equal to a value" and then I can only choose one specific cycle.
Is there no way to dynamically create table to table imports like this? If not, how would you recommend I capture the status of the Cycle Records table. I want to capture the state of this table at a specific point in time, not track every single change in that table.
Thanks!