Sam Ceccola
08-01-2006, 10:27 AM
OS = Windows XP Pro - SP2; Crystal Reports XI Developers Edition
Table-A
dbPartNumberA
Field-2A
Field-3A
Field-4A
Table-B
dbPartNumberB
Field-2B
Field-3B
Field-4B
Both tables are in the same ".mdb" MS Access Database
Field names in both tables are unique but have the same meaning. Example: dbPartNumberA and dbPartNumberB are both Part Number's however there "value" is different and they are in different tables because of logic differences.
What I need to do is to produce 1 report that will list the data of Table-A and Table-B in Part Number sequence. Remember the Part Number can come from either Table-A or Table-B.
Can this be done in CR? If so, can you explain how?
Thank You,
Sam
Table-A
dbPartNumberA
Field-2A
Field-3A
Field-4A
Table-B
dbPartNumberB
Field-2B
Field-3B
Field-4B
Both tables are in the same ".mdb" MS Access Database
Field names in both tables are unique but have the same meaning. Example: dbPartNumberA and dbPartNumberB are both Part Number's however there "value" is different and they are in different tables because of logic differences.
What I need to do is to produce 1 report that will list the data of Table-A and Table-B in Part Number sequence. Remember the Part Number can come from either Table-A or Table-B.
Can this be done in CR? If so, can you explain how?
Thank You,
Sam