Combine Fields into One and put AND before last ( if applicable)

[rpatil]

I have tblProductName ( ProductNumber and TradeMark )



Sample



ProductNumber TradeMark



123 T1

123 T2

234 T4

234 T1

123 T6

456 T3

123 T7









I have different table tblMainProductInfo ( ProductNumber and TradeMarkCombo)



ProductNumber TradeMarkCombo

123 T1,T2 , T6 and T7 are registered trademark of XYZ corp.



234 T4 and T1 are registered trademark of XYZ corp.



456 T3 is registered trademark of XYZ corp.











I have Main form based on main table “tblMainProductInfo” that has subform based on “tblProductName”





I need to create a code on subform such that if user add or delete a trademark from the subform it should update the relevant TradeMarkCombo filed on the main form.





e.g. say user is working on product code 123 ( subform will show T1 , T2 , T6 and T7 on separate rows) and the user deletes the row that has T2 , the main form TradeMarkCombo should be updated to



T1, T6 and T7 are registered trademark of XYZ corp.







Does anyone know how to write code for this



Thanks