Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2013
    Location
    Philippines
    Posts
    103

    Unanswered: Moving to any record in the many to may relational field

    Hi Guys,

    Is it possible for BD to move the cursor to a certain row in the many-to-many relational field?

    Thanks

    Ernie
    Last edited by mcmichael; 03-20-14 at 19:06.

  2. #2
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Hi Ernie
    Only the first and last row as fas I am aware using Edit MMR action. What is the reason for this action - there may be a work around?
    Regards
    David

  3. #3
    Join Date
    Oct 2013
    Location
    Philippines
    Posts
    103
    Hi David,
    I wanted the entry in the many-to-many relational field to be unique. When the user enters a duplicate record in the many-to-many relational field, BD will give the user an option to edit the entry. I wanted BD to jump directly to the record when the user chooses to edit the content of that record.
    Thanks
    Ernie
    Last edited by mcmichael; 03-21-14 at 08:26.

  4. #4
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Hi Ernie
    Just some thoughts. If you create a new record in M2M field with a button script rather then allow clicking in the M2M, then you have better control. BD will create a record set variable with the new record which means you can can always locate this record for futher actions (for each record loop action).
    Another idea would be a time stamp on edit and sort M2M on this to make it first in list, which is accessable with a script (Edit MMR or may be lookup).
    Keep in mind it is possible to add the "internal" record id to each record with a maths field set to the current record via recordset variables (current) and script run on comfirm etc). You then can access this record at any time using this stored field value directly - also handy as a unique value.
    Regards
    David
    Last edited by tamcind; 03-22-14 at 18:38.

  5. #5
    Join Date
    Oct 2013
    Location
    Philippines
    Posts
    103
    Hi,
    Thanks. Great idea David. I already have a version which uses button script to create a new record. I will try your suggestion.
    Regards
    Ernie
    Last edited by mcmichael; 03-22-14 at 23:20.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •