Hi,
I have an IP2007 form which contains two repeating tables. One of the tables is linked to an Access DB. The other allows the user to enter leave detail information.
I would like to filter the records from the repeating table which is tied to the Access DB using the start/end date parameters in the other repeating table.
I have tried using the current function when filtering the data. It returns the expected value the for the first row of the repeating table, however it uses the same data (first row) when filtering for newly added rows.
Is there any way I can get this to work properly?