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,

Jan

Top
#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: 481
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.

Top