[Isis-users] Linking records - multiple occurrences problem

Guilda Ascencio guildaa at gmail.com
Wed Nov 14 20:12:12 CET 2018


Hi Renate.

ABCD was programmed to deal with 2 kinds of relationships between databases:

1.  One to one  using the ref command of the isis formatting language
2.  One to Many using the $$REF command of ABCD

The relationship between your databases is Many to Many because the linking
field is repetible and each occurrence points to many records of the linked
database.  So, I did some changes in order to solve you request:

Place the scripts fmt.php and leerregistroisis.php in central/dataentry
folder and change the display format in this way:

/'$$REF:track,track,MID_'v20+|$$|/

Each occurrence of v20 will be separated with $$ and the routine for
displaying the record will build a search expression which includes all the
occurrences of v20.

Is mandatory that the prefix for searching the records in the linked
database ends with _ (underscore).

Let me know if it works for you

Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20181114/9a68a7bc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: leerregistroisis.php
Type: application/octet-stream
Size: 7720 bytes
Desc: not available
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20181114/9a68a7bc/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fmt.php
Type: application/octet-stream
Size: 34432 bytes
Desc: not available
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20181114/9a68a7bc/attachment-0001.obj>


More information about the isis-users mailing list