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.
Edited by Jonathan Wood (08/15/12 04:42 PM)