how to get the desired field from one table using another table fields

Hello Everybody,

Sorry for posting this silly doubt. Actually in my WDA application I have 4(for four processes : these are present in main table) dropdown list and 1 textedit box(for comments update : this is present in one comments tabel). So my requirement is that when user select any dropdown from among the 4 dropdown lists and types any comment in the text box, the comments field in the main table as well as comments table should be updated for that process and not for all processes.

The main hurdle for me is that even if the two tables are joined by foreign key I couldn't make the table updated with perticular process and with new comments that entered by the user.

can anyone suggest me what to do in this case...?? 😔

thanks,

sekhar