How do I fill (add data, not Filter data) into a Table using a form, then display in a table on the same form?

Ask the community
,
1

I have a form to add medication into a collection.


I enter Medication, Qty and Dose info. When I press the button, it adds the data into my Prescriptions Collection. The table below the form, should then show the items in the Prescriptions Collection after each button press.
I have this form linked to the Prescriptions Add Dataset as Write Only.
The table (seen below the form) connects the the Prescriptions Read Only as Read Only.

How do I get each medication added into the table when I press the button?

Any help would be appreciated.

2

422×785 22.9 KB

You should have an option to SUBMIT the prozess. Write-Only is ok, but you won’t be able to read out data using this DATASET.