relational database questions

[Jeff Kozuch]

> So my questions are, first in panorama can I display the related  
> information from one table in another (in the donor table form to
> display as well the related donations). I am also wondering the  
> line Item use. Is this kind of against the idea of relational  
> database ?
> and am I kind of force to the use of line item when I want to work  
> with multiple item invoice or donation?

First question:

Yes. There are many ways to display information from one database to  
another including lookups with TextDisplay SuperObjects,  
ListSuperObjects and the SuperMatrix object being the tools most  
used. Displays can consist of one line simple lookups, combinations  
of simple lookups or heavily filtered arrays. There are lots of  
examples of how to use the SuperObjects in the manual.

Second:
Line items have their place but it becomes more difficult to  
manipulate the data if you use line items. If you are comfortable  
with line items, one trick is work with line items, then export the  
line items as individual records to a second file for data  
manipulation. However, to avoid this step, especially if you intend  
to do lots of massaging and array lookups, you would be better off  
using individual records.

Good luck!


Jeff Kozuch
President, Acacia Systems
Apple Certified Technical Coordinator
Certified Member, Apple Consultants Network
jk at acaciasystems.com
http://www.acaciasystems.com
562-437-7690
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080429/1bb5ebfa/attachment.html