These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#56802 - 02/27/19 02:42 PM Variable table (various lines from databases)
Jan Ceulemans Offline
OL Newbie

Registered: 02/27/19
Posts: 1
Loc: Erembodegem, Belgium
Hi all,

First of all, I am happy to have found this forum smile

I have a question (of course) wink

You see, I need a layout, which contains a letter to a client. This letter is single sided and on top there will be the address.

However, on the same page there should be a list of members who belong the the person to whom the letter is written.

For one client it could be 10 lines of members, another one may as well have 55 members.

My question is two-fold:

1) I use MS-Access as database. How should I arange the tables? One table is the adresses of the clients, another table would hold the members of eacht of these clients.... should I make a relation between those two in access?

2) How can I create a layout in such a way that records only proceed when all members are displayed on a list?

So, I need a letter and a variable list. Can this be done in PSM?

Realy hope there is a solution.

Best regards,


#56803 - 02/27/19 04:48 PM Re: Variable table (various lines from databases) [Re: Jan Ceulemans]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 681
Loc: Québec, Canada
Not having access to your DB makes kind of hard to test and found a working solution.

I suggest to open a technical ticket on our website.

This way, a technician will be able to remote at your site and work with you in this.
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code