Hello,
So I have this simple database that contains only two tables. one contains customers information the other contains their payments.
I made a main form that pulls information from a query based on these two tables. When the user clicks on a record in this main form another form opens that shows the payments of this specific record, I did that using simple code in the where clause in on click event of the name field. My problem now is that when the user wants to add new payment on this second form they can enter a payment to any other customer not only the one that they clicked in the main form. How can I limit the second form to only the record that the user clicked in the main form. I attached my database.
Thank you very much
So I have this simple database that contains only two tables. one contains customers information the other contains their payments.
I made a main form that pulls information from a query based on these two tables. When the user clicks on a record in this main form another form opens that shows the payments of this specific record, I did that using simple code in the where clause in on click event of the name field. My problem now is that when the user wants to add new payment on this second form they can enter a payment to any other customer not only the one that they clicked in the main form. How can I limit the second form to only the record that the user clicked in the main form. I attached my database.
Thank you very much