Meetings.dbf lastname,firstname,isblock,blockslot,schdate blocks.dbf lastname,firstname,blockslot,schdateIn the first table individual patients are scheduled or a block is defined. If it is a block than isblock=.t..
Example: Meetings.dbf with 2 records LASTNAME FIRSTNAME ISBLOCK BLOCKSLOT SCHDATE ======================================================= KELLY KIRK .F. 1234 10/07/2001 BLOCK BLOCK .T. 1235 10/07/2001 Blocks.dbf with 1 record LASTNAME FIRSTNAME ISBLOCK BLOCKSLOT SCHDATE ======================================================= KELLY ROGER .F. 1235 10/07/2001 Desired Results: LASTNAME FIRSTNAME ISBLOCK BLOCKSLOT SCHDATE ======================================================= KELLY KIRK .F. 1234 10/07/2001 KELLY ROGER .F. 1235 10/07/2001Any help greatly appreciated