>I have the following chuck of code:
>
>
>SET EXACT ON
>use g:\dp\ic_utils\data\mail_dbfs\CAN102599.dbf alias asgn_data &&&this file will have the locations last mailed
>sele 0
>use C:\TEMP\mailing alias repo_data
>index on sITEID + studio + title to c:\temp\index
>select asgn_data
>set rela to siteid into repo_data
>set skip to repo_data
>
>SELE REPO_DATA
>GO TOP
>
>REPO FORM FIELDFORM NOCO TO PRINT PREV
>REPO FORM FIELDFORM NOCO TO PRINT PROMPT
>
>when i run this in my program I am getting everything from repo_data. I only want what is in repo_data and asgn_data matching on siteid. This is a one to many relationship where one asgn_data record could have many repo_Data records.
>
>Any help would be greatly appreciated.
>
>Thanks,
>Todd

Then your relation is backwards. It should be Set Relation To SiteId Into Asgn_Data. You will probably want to put a scope clause in the REPO command.