Good afternoon,

We are currently reviewing the production suite for our agency and ran into an issue, we have relational data and de-normalizing the data in a query then taking the columns to add to a page yields undesireable effects.

Sample would be that you have two database tables joined in a one to many relationship.

First table has basic client information, for arguments sake, it has an id filed for that client, the client name, and producer on the account.

Second table has a policy id, client id to relate back to the client table, general policy information such as premium, effective date and expiration date.

Now, if these two were joined in a query the resulting information would come back as:

1...Client ABC...Jane Doe...100...1...10000...1/1/2012...12/31/2012
1...Client ABC...Jane Doe...101...1...12000...1/1/2011...12/31/2011
1...Client ABC...Jane Doe...102...1...15000...1/1/2010...12/31/2010

Now on the form I want to have the header section show the client name and producer then a sub section I want just the policy information but when I drag the fields on it brings in more than just that one data, it brings in all of the client information in triplicate plus the data.

So now what.

Hi Jonathan,

There has to be something done wrong when showing the data, because you should have the liberty of showing any info as is on the page. Can you provide details on how you are selecting the data to show on the form design? What is the DB format you are using? Did you build some advanced SQL query in your form emulation? Or did you extract the info you needed into a file?

Please try to clarify a bit your situation. Thanks.
Regards,
Olivier