When constructing a report, one can tell the system not to repeat data
so that it prints only once. Alistair, I suspect that you constructed
this system back in the day, when reports did not have that facility. I
use it quite often.
Albert
On 10/16/2014 3:29 AM, Alastair Burr wrote:
Bruce,
It’s actually two tables – the item one contains common info such as
overall time, dates, etc.
The tracks one contains title, artist and running time. Other tables
contains writers and publishers, musicians and instruments, comments, etc.
Any idnumber than ends in “00” refers to the whole item so musicians,
for example, that play on all tracks only get listed once rather than
for every track. It’s partly a throwback to the days when space was at
a premium but mostly because it keeps reports much more concise
without repeating the same info for every track.
Although tracknumber “00” technically often exists in the reports I
replace it with a space. Obviously, it sorts before track number 1 so
it follows the item or header data. On forms I use it so I can enter
common data.
Regards,
Alastair.
