Currently I have a Form for entering 'line items', Submit button to Collect it to the same collection, and then a Gallery to Display said collection. This is eventually Patched to SQL later in my app, however I'm having trouble editing records since I don't have a unique key in a collection.
Essentially the Form is pointing to the Collection colLineItems. Since it's not a true datasource, all of my cards are custom cards, and my submit button simply collects the values of each text box, resets the form, sets it as a New form, and sets my LineItemSelected variable to Blank(). (That variable is populated with the selected item from the Gallery)
The Gallery is pointing to the same Collection, however if a user wanted to edit one of those records, my collection data is too dynamic to have a unique key. I was looking into including an incremental Sequence number an a sort of temporary key, however there's a chance that those wouldn't be unique either since costs and quantities are two of my Form fields.
Any ideas? I know this is an atypical use of a collection in a Form, but surely someone has tried to create something similar to this. I'm just not sure what the best way to go about it is.
Thanks in advance!
