how to set data of field based on previuos record

[newegyptian]

How i can set data in certain field of record . Based on data of field in previous record.
Or how to be based on data field of first record



Thanks

[ranman256]

records cannot see each other....And shouldnt be.
What do you want from the previous record?

[newegyptian]

records cannot see each other....And shouldnt be.
What do you want from the previous record?

The patient come to me as visit of examenation so the next visit will be consultaion and next will be examination again then next is consultaion and so on
Each is based on name of previous record

If previous is examinatio so it will be consultation and vise versa

[Micron]

If you're using a form (as you should be) the DLast function can return the status for a given person if based on a reliable progression (such as last visit date). You then set the status for the new record appropriately. If you wish, you can employ validation code so that the new value cannot be the same as the Last value.

[newegyptian]

If you're using a form (as you should be) the DLast function can return the status for a given person if based on a reliable progression (such as last visit date). You then set the status for the new record appropriately. If you wish, you can employ validation code so that the new value cannot be the same as the Last value.

should i put dlast function in expression if the field box or where
please geiv me steps slowly

[orange]

I would recommend a query with a where clause to get latest Visit date for this patient etc.
I would not use DLast --which says

You can use the DLast function to return a random record from a particular field in a table or query when you need any value from that field.

I have seen issues reported with DFirst and DLast, so opt for queries.