Hi I have 2 Tables one for Despatch Orders - DO (Parent) and the other DO_Items. When I create a new DO, It should automatically create records (DO_Items) in the child table based on a column called Items - that is an enum list in the parent table.
How to do that ?
FAQ: add row per value in EnumList Tips & Tricks ?
Add one row per value in an EnumList column list. Try the sample app! For this example, the table from which the row-addition process will be initiated is called Control Table. The table to which new rows will be added is called Target Table. Use your own names as you see fit. Note that they could even be the same table. Control Table must allow updates; Target Table must allow adds. Control Table must have at least two columns for this process: EnumList (type EnumList; a list of Enum values;…
Thanks Steve,
Bang on Yet again .
This should work in my case I feel. Let me try out.
It will !!