Hi,
I've One to many linked tables by a short text field "ItemID", the main table "MainT" contains 100s of records, the linked table "DataT" is blank & contains 3 fields; "ID", "ItemID" and "Job", jobs are listed on a table "JobT"As shown on the below picture.
Is it possible to filter "MainT" by one or many of its fields then insert many "job"s records into the linked table "DataT" for all filtered record on "MainT"?
e.g. If I filtered the "MainT" by material "SS" the result will be 2 records (A9 & A10) then from an unbounded controller(s) I will select 3 jobs to be added to the "DataT" for all filtered items i.e. 3 jobs will be added to A9 & to A10 on "DataT".
Note: Access example is attached
Targeted items to be added to DataT
ID ItemID Job 10 A9 Cutting 11 A9 Forming 12 A9 Welding 13 A10 Cutting 15 A10 Forming 16 A10 Welding
Note: I used Multi Values Field for Job on the main table before but I changed to a linked table due to its difficulty for selecting, copying, editing and erasing.