Re: Form and M2M relations

Well, I think you'd better create a based block B as detail of master block C.

If not possible for some reasons try this:

  trap KEY-COMMIT or any event that mean user want to commit changes. Theses events have to launch your own COMMIT_MY_FORM procedure:

begin
  Retrieve datas from non_based items
  COMMIT_FORM
end

Good luck,

        Yann.

peterlon a écrit :

> Hi,
>
> I have to deal with a many-to-many relation between table A
> and B. The relation is implemented by the aid of table C
> which contains the FKs of table A and B.
> Consequently I created a block of database items (which
> are not displayed in any canvas) based on table C and text
> items that are populated by the mean of post-query-trigger
> with the data contained in table B.
> I would like any changes to the values of text item to be
> reported in the database too. I think to use
> when-validate-trigger/pre-insert-trigger to handle this
> event.
> Unfortunately when somebody change the text item, the
> status of the associated record remains unchanged (i.e.
> Query) so, apparently, there is no way to realize that
> this change occured.
> Can anybody tell me if there is a way to handle this
> problem?
>
> Thank you in advance,
> Andrea
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Mon Sep 27 1999 - 09:29:56 CEST