Search the Community
Showing results for tags 'copy data'.
Hello, I have a table with N records, where I have a field that is repeated on occasions. I need to select the most current records (oldest date) of each identifier and save them in a table, so that I have something like this: I need to save only 1 value per identifier and that is the one with the most current date. I am thankful for any kind of help.
Assume following Table schema: Hi, My desired work flow Insert a date record into tbl_Inventory Count_Dates On INSERT, tigger the following: Loop through tbl_Inventory_Items - a list of each item to be counted - and insert a copy of each item into tbl_Inventory_Count_Detail, along with default value of 0 for Count of each record. This results in a record including new id, Count_Date(which triggered the event), Material_id, Material_Name, and Count (Set to 0). The purpose of this is to be able to filter tbl_Inventory_Count_Detail by Count_Date and use as a data source/view for a Tabular report datapage that allows user to enter a dated physical count for each item. @CraigSZ - I think this is similar to the direction you suggested in earlier post. Hoping I can do this all with a looping triggered action - Just not sure on Syntax. Any help would be greatly appreciated...Thx...