Dynamically pre-load from data in Aggregate?

Hi all,

Is it possible to dynamically pull data already stored in Aggregate into a
form on Collect?

Form1: Register a sample/user/household/item/etc by assigning a unique
Form2, 3, 4, 5 etc: Collect further data on that previously registered ID.
Ideally it would be possible to select the ID from a pre-populated select
list as opposed to having to manually enter it.

I realise this could be done via the pre-populate data method described in
the docs but am specifically looking for a dynamic means - i.e the
Aggregate database would be queried on the fly for possible options.


I don't think you'd be able to query it on the fly via aggregate, but you
can create CSV data-sets by running few SQL queries specifically used in
later forms for mapping the same ids as in form 1.