<div dir="ltr"><div><div>Go to <a href="http://abcdwiki.net">abcdwiki.net</a> spanish->demo abcd with no copies-> Cepal database->new record ->monografías -> existencias -> click on then + icon. I think is not difficult to enter the information of a repetible field in that way.<br><br></div>Another thing you can do is assign an identification number to the each CD and identify the track with the same number, also you must have 2 types of record: CD and Track. You can use the picklist procedure for copying in the tracks some information of the CD (see <a href="http://abcdwiki.net/wiki/es/index.php?title=Pasar_a_un_registro_la_informaci%C3%B3n_de_una_base_de_datos_relacionada">http://abcdwiki.net/wiki/es/index.php?title=Pasar_a_un_registro_la_informaci%C3%B3n_de_una_base_de_datos_relacionada</a>)<br><br></div>Then using a proper FST and the the display format the command (only available on ABCD. See http://<a href="http://abcdwiki.net/wiki/es/index.php?title=Formatos_de_salida_que_integran_la_informaci%C3%B3n_de_bases_de_datos_relacionadas">http://abcdwiki.net/wiki/es/index.php?title=Formatos_de_salida_que_integran_la_informaci%C3%B3n_de_bases_de_datos_relacionadas</a>) <br><pre>/'$$REF:Base_de_datos, Formato, Expresion de búsqueda'/<br><br> you can integrate in one display the information of the cd and the tracks<br></pre><div>When you browse the data base by Mfn you will display the cd record and the tracks record, but if you do a search you could only recover the CD and you will see the tracks as part of the CD record.<br><br></div><div><br>But, if you ask my opinion, I think is easier and more consistent having the tracks as a repetible field of the CD record.<br><br></div><div>Regards<br><br></div><div>Guilda<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Mar 17, 2015 at 3:10 AM, Renate Morgenstern <span dir="ltr"><<a href="mailto:rmorgenstern@iway.na" target="_blank">rmorgenstern@iway.na</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>
<div>
The track information is not only the track title, but it entails all the information: artists, publisher, composer, record label. etc, etc.<br>
There are really many fields for the track info, and to enter this is one repeatable field is not very easy for data entry.<br>
Regards<br>
Renate<br>
<br>
<blockquote type="CITE">
Abcd is record oriented. What you can do is one record for CD and each track an occurrence of a repetible field<br>
<br>
</blockquote>
<blockquote type="CITE">
<br>
</blockquote>
<blockquote type="CITE">
On Mon, Mar 16, 2015 at 4:21 PM, Renate Morgenstern <<a href="mailto:rmorgenstern@iway.na" target="_blank">rmorgenstern@iway.na</a>> wrote:
</blockquote>
<blockquote type="CITE">
<blockquote>
Hi Guilda,<br>
<br>
<br>
I have a music database which consists of the CDs and one records fro every track on the CD, which in the display links to the CD.<br>
I also would like to have in the display that it should list all the tracks on the CD, but for this it only lists one track, and the others.<br>
<br>
Currently it looks like this when the CD title is displayed:<br>
Record no: 020005<br>
Library No: CDE01158A<br>
<br>
CD-Cover Title: Greatest Hits [Dan Fogelberg]<br>
<b>Other tracks on CD : Part of the plan</b><br>
Album type:Same artist(s)<br>
Dan Fogelberg<br>
<br>
How can I get the display to list ALL the tracks?<br>
Here is the PFT:<br>
<br>
Thanks for the help,<br>
Renate<br>
<br>
==========================<br>
<br>
(if p(v800) then '<tr><td width=20% valign=top><font face=arial size=2>'v0| |,'</td><td valign=top><font face=arial size=2><br>
<img src="../common/show_image.php?image='v800'&base=music" width=70 target=top>'/'<br></td>' fi/)/<br>
<br>
'Record no: 'mfn(6)'<br>'<br>
if p(v20) then 'Library No: 'v20+|; |'<br>'/fi/<br>
if p(v78) then 'Library No: 'v78,'<br>'fi/<br>
if a(v1) and p(v41) then "TRACK: "v41,/'<br> ON CD: ',ref(l(|LIB_|v78),v1," : "v2), fi/'<br>'<br>
if p(v1) and a(v41) then 'CD-Cover Title: ',v1," : "v2," ("v3")",fi,'<br>'<br>
if p(v1) then 'Other tracks on CD : ',ref(l(|MID_|v20),(v41," : "v44|<br>|)), fi/'<br>'<br>
if p(v55) then 'Album type:'v55,'<br>',fi/<br>
if p(v4) then if occ=1 then 'Variant titles:',fi,v4 '<br>'fi/<br>
if p(v8) then if occ=1 then 'Artist or choir or orchestra:',fi,v8,'<br>' fi/<br>
if p(v9^a) then if occ=1 then 'Composer:',fi,v9^b| |v9^a,'<br>' fi/<br>
if p(v12) then if occ=1 then 'Author:',fi,v12,'<br>' fi/'<p>'<br>
if p(v154) then 'Status:',v154+|; |,'<br>',/fi/<br>
<br>
(if p(V41) and a(v1) then `<a href='javascript:CruzarABCD("`v1,|, |v1`","MID_")'>` v1,|, |v2`</a>`,if iocc<>nocc(v41) then `; ` fi fi/)<br>
<br>
'<br>'<br>
<br>
<br>
<span class=""><font color="#888888">
</font></span><span class=""><font color="#888888">
</font></span><table cellpadding="0" cellspacing="0" width="100%">
<tbody><tr>
<td>
<br>
<br><span class=""><font color="#888888">
</font></span></td></tr></tbody></table><span class=""><font color="#888888">
</font></span></blockquote><span class=""><font color="#888888">
</font></span></blockquote><span class=""><font color="#888888">
<table cellpadding="0" cellspacing="0" width="100%">
<tbody><tr>
<td>
-- <br>
<br>
Renate Morgenstern<br>
Tel.: <a href="tel:%2B264%2061%20242124" value="+26461242124" target="_blank">+264 61 242124</a><br>
Cell: <a href="tel:%2B264%2081%202910284" value="+264812910284" target="_blank">+264 81 2910284</a><br>
Fax: 088637518<br>
Windhoek, Namibia
</td>
</tr>
</tbody></table>
</font></span></div>
</blockquote></div><br></div></div>