Hi Val.
I made a teeny mistake with my question lol.
I meant to ask the same question only about the "retrieve value from table".
So my 2 questions regarding this action: "Retrieve value from table"
1) This action has an option to say "If multiple results, Retrieve first". If this option is selected, when method finds a record matching the criteriia will it stop processing and give me back that value or will it continue to find every record that matched my criteria then go back and choose the first one from that list? ... Obviously the latter is a bit redundant.
2) I don't know how direct the access is for the programmers to get at these tables' records, but is it possible to streamline this action when retrieving a value whose record number you already know? So if i asked for field "myField" at record number 42 ... is method able to return back (example):: MyTable.myField.record(42) .... instead of traversing the entire table of say 60 records looking for all 42s .. followed by returning the only one it found.
Method may already be as streamlined as it gets on these programmatic features ... I'm only asking so that when i go to use these features I can take the fastest route possible and not get stuck using a generic form that will get the job done but run like a slug when needing to find something multiple times that could otherwise be more easily retrieved if coded differently or a new action was created with that in mind.
Thanks,
~Joe