Multiple occrance of same record even if it exists once in the table.

[paramsocool]

I am pulling two tables from a same database source. The tables have exactly identical field names but the table names are different. I have to pick up some dates from the two tables. Same record may exist in both the tables...One of the table is a current table and the other one is History table. Any status of a record that was in current table goes to the history table if the current table is updated.
The problem I am getting is that when I am displaying the account number and the dates from one of the table only the account number is repeated multiple number of times even if it existed just once in the table....can any one advice why this behavior is occuring.

The other thing is a want to do a full outer join but that option is not active in my CR X1...is it some setting or the table structure /database I m using.?

Thanks for your advice

 

[synapsevampire]

Post the database and Crystal version...

Sounds like you've been thrust into data somewhat green, your first problem is likely row inflation/record inflation, read up on that a bit.

Why do you need a full outer join? Anyway, Crystal doesn't support it for the most part. Use the Add Command listed under your data source and paste in SQL for a Full Outer or a UNION ALL (which sounds like what you really neeed).

-k

 

[Madawc]

Suppose you link records in table A to records in table B. If record A links to B1, B2, B3, B4 and B5, you get a detail line or 'row' for each. Fields from record A appear in each 'row', which is just what a programmer would want for some purposes.

If this isn't what you want, the standard answer is to group on something, maybe an account number. Suppress the detail lines, show the detail in a group header or footer.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10