>You say the report shows only 3 records. I assume you mean the cursor of the view holds 3 records?.
>What is reccount("NameOfMyView"), _TALLY after requery, how many records are visible with a browse?

Yes cursor of the view. I did a browse,. 3 records

>A view is an odd way to store SQL selects. So we talk about the SQL SELECT.
>Get the view definition and run from command line or a Modi Comm window.

All the data in the tables were created. so executing from command window after quitting the app will show me all records.

>
>The basic stuff limiting the return of a SQL SELECT:
>Value of SET('DELETED')?
>Is the view using DISTINCT, GROUP BY (HAVING) or UNION?

No

>Are there WHERE or ON clauses?

Yes

>JOIN set to the wrong side?

No

>Else you need to check your frx. Use a copy of the existing frx and remove item by item. If it will not help, recreate the frx step by step while running it after each step. EACH.

FRX shouldn't be the problem because if I quit the app and get back the browse show me all records. and reports also show 4 records.

>
>>Hello all,
>>
>>I need a report to show all data that is selected but there is one record missing in that report.
>>
>>All data required is present in all tables.
>>
>>I am in a screen where some data is added to some tables. After the needed data is created I go to see that data in the report but there are only 3 records showed when there should be 4.
>>
>>If I get out of the application and get back then all the records appear in the report.
>>
>>After the creation of the data is done in the screen if I go to see another report and then get back to the faulty report, all the records are showed (4)
>>
>>I thought that adding a view in the data environment would solve the problem but nothing is changed.
>>=requery("NameOfMyView") changes nothing. Only 3 records showing.
>>
>>I thought changing to private data session in the form creating the reporty would change something. Nothing chnaged.
>>
>>What should I do to fix this?