[Zope] Linking two tables

Anders Gaarsdal Holst anders@colorweb.dk
Fri, 19 Nov 1999 14:49:01 +0100


This question might be slightly off topic. But anywhere here it is:

I have two tables in my MS Access database:
1. Containg a record for each employee

2. DVD database containing a record for each DVD

What I would like to do with Zope, is to somehow link these two
together, so that I can write on my intranet that  Mr. X has DVD this
and that.

My problem is that I can offcause make a field in the first table
(employee table), where I list the IDnumbers of the DVDs (seperated by
commas), which the employee owns, but then a query returns these id's
comma seperated and I don't how to handle this (in a <dtml-in> -loop).


Regards,
               A n d e r s  G a a r s d a l  H o l s t