>>SELECT DISTINCT Client_num, Client_SRC, FName, LName ;
>>FROM Ver ;
>>UNION ;
>>SELECT DISTINCT Client_num, Client_SRC, FName, LName ;
>>FROM Bal ;
>>INTO CURSOR Billable_Clients
>>
>>Again, the UNION will filter any rows that appear in both tables.

>What happens if Jimmy Jones is in both ver and bal? I want him to show up in the final table, but only once.

As long as 'Jimmy Jones' has exactly the same Client_Num, Client_SRC, FName, and LName in Ver and Bal, the UNION clause will produce just 1 row in the final table/cursor.

Note: If you actually WANTED to see the rows repeated, you change 'UNION' to 'UNION ALL'.

>BTW - I love your flag!

Thanks! I think the Marshallese did a good job on it, too.