Hi,
what I really want, is a form dataset that input the collection to add records but that also extracts from a dropdown a specific already existing record in the collection and update some fields and reSubmit the updates to the Collection.
I need advice on how to do this!
The version that will add new records to the collection is already working fine. The form dataset is in Write Only so it will accept new entries.
If I change the dataset to Read and Write, I get the latest data in the form dataset fields
Just would like to select via a dropdown which record is visible on the form in order to have the possibility to update the Collection.
Thank you help would be much appreciated.