Hi All,
I have a tbltools that has 12 fields in total of which 2 fields (Machine & Tool Type) that I need to apply a custom sort order to in the user report, so I have have added two sort fields to the table (Sort Order Machine & Sort Order Tool Type) this approach works fine but I need to implement a Form so the admin user can makes changes to the sort order and add/delete extra criteria to the sort.
ie if a machine or tool type is removed or renamed in the form then I would like it to be removed/updated from the relevant records in tblTools.
I am unsure of the best approach, I was thinking of making dedicated sort tables for machine and tool type but am not sure what relationship between the tables I need for cascade update and delete.
Can anyone explain/demonstrate the best approach
Thanks
I have a tbltools that has 12 fields in total of which 2 fields (Machine & Tool Type) that I need to apply a custom sort order to in the user report, so I have have added two sort fields to the table (Sort Order Machine & Sort Order Tool Type) this approach works fine but I need to implement a Form so the admin user can makes changes to the sort order and add/delete extra criteria to the sort.
ie if a machine or tool type is removed or renamed in the form then I would like it to be removed/updated from the relevant records in tblTools.
I am unsure of the best approach, I was thinking of making dedicated sort tables for machine and tool type but am not sure what relationship between the tables I need for cascade update and delete.
Can anyone explain/demonstrate the best approach
Thanks