Posted on 2006-06-23
I've to design a form to accomodate the following:
the two main fields in the form are account id and sub account id.
each account id can have multiple sub account id's.
and there can be multiple account id's.
so the relationship is multiple account id's and each account id will have again
multiple sub account id's.
what is the best way to store this. I cannot use a multiple value field for both
becuase there can be more values than the 32K limit (I think the limit in domino for a multiple value field seperated with commas or semicolumnis is 32K).