Dups on recods line
Posted: Mon Feb 04, 2002 4:03 pm
I am new to R&R. I just created a report using 3 dbf^s.____The problem I am having is that on certain members the scaned data table is giving the results twice. I have no idea why. If someone could help me I would really appreciate it. I would be willing to email you the report & data only 300K compressed. I wouldn^t mind calling you either to discuss in better detail. I can^t afford to pay tech support so any halp would be great. Joe@griban.com __ ____ DBF^s Join Fields that are important __ ---------- ------------------------------__table one > prospects ...memberno__table two > meminfo ...memberno & HHnum are important__table 3 > hhinfo ...hhnum____hhinfo is a head of household dbf, this contains main info like address, city state & Zip____meminfo is a member dbf that ties thru hhnum, there may be several members with the same hhnum but have a unique memberno____prospect has a list of prospects by memberno.____so what I believe I needed to do is make prospects my Master table__then tie it into meminfo, then tie meminfo in with hhinfo, then scan minfo by the hhnum which will give me all the members within that family.____