have 3 database with:
1. Master with header "Stock Code Description Image Quantity Reorder Quantity Remark"
2. ServiceLog with header "ServiceID Customer Name Item Brand Motherboard Model Quantity System Date Received Date Returned Problem Action Taken Item Replaced"
3.ServiceDetail with header "ServiceID TransactionID Transaction Date Stock Code Quantity Transaction Type Purchase Price Recommended Sale Price Supplier Transfer Location Customer Name Remark"
Previous approach:
1.In Master, "Add replaced item" where record table is "Master" and add a new row to another table "ServiceDetail", using "ANY(SELECT(ServiceLog[ServiceID],[ServiceID]=MAXROW("ServiceLog","_RowNumber")))" in ServiceID
2. In ServiceLog, i have "Trigger Add" which ref to Master database and trigger "Add replaced item" with referenced rows "SELECT(Master[Stock Code],IN([Stock Code],[_THISROW].[Item Replaced]))"
3. In ServiceLog, i have group execute sequence of action where action is "Trigger Add" and record table is "ServiceLog
Problem:
1. how to get current row "serviceID" from ServiceLog when add or remove "Item replaced", the expression for the action "Add replaced item" in Master?
2. how to delete the record of "ServiceDetail" when item removed from "Item replaced" where the "Item Replaced" look like "Item1, Item2,Item3" but in "ServiceDetail" it shows in row for each items?
any idea how can i improve this?
LinkedIn
Twitter
