Thank you for your fast response.
I dont want to link the data of two tables, but CR links them by some auto-arrange.
I have two tables let's say:
1) Table 1 (main data sourece) contains Customer ID (key), Customer Level (Non-key)
2) Table 2 (just a few records for lookup for Customer Level description) contains Customer Level, Customer Level Description.
Now:
I tried to link the Customer Level from table 1 to table 2. CR 10 does not link it correctly for me so I tried not to link them by CR still linked them and created wrong/duplicate records.
So I plan to just connect the second table, dont link it the the first table, write a function to get the Customer Level Description onto the report.
Hope that it clear. Thank you, Brian. There must be a simple way ???
IP Logged
