Hello.
i have a single record form (form2) which is called through a button from form1. the link between them is the patient id. in the SQl setting of the form2 there is this WHERE clause idpatient = [glo_ref_idpatient]
The problem:
after i insert a new record in the form2, in the toolbar of form2 i see what is shown in the image attached (“immediately-after-insert.png”) which is weird because it shows me all the records in the table related to form2 regardless of the idpatient.
After clicking the previous or next record arrow it shows me correctly only the record related to the patient (see “after-hitting-previous-next.png”) which in this case is 3.
this is very annoying and confusing for the final user. what could be the problem?
Thanks