>Ravi,
>
>Yes, I see what you are trying to do now. It looks like you need multiple detail bands, so you have to overcome the limitation of the VFP report writer. See Thread #506110 Message #506279. You may be able to pull it off without literally putting the different field types on top of each other...you may be able to stack them vertically and use "remove line if blank" to get the desired effect. But the key is to have one cursor containing all the information, with a field that serves as a flag to determine what kind of record needs to currently be printed in the detail band.
>
Hi again Steve:

The third table will be added to the select statement. There are two common pieces of information in all three tables, namely, Date,and PhysRef (a unique number that is generated each time a new physical is done).

- Ravi.