Dear all,
first, I have to tell that I know only the basic fundamentals of access.
I have created a basic access form to enter my client's data and their contact details. so there are two tables. When a client comes I have to enter his details in the main form and I have to enter the service why they came to me in the subform.
now my question is, ones I put their details to the form if they come again after a few months later how can I update same profile since CLIENTE ID field is auto number. because I want one profile and multiple contracts.
pls, refer attached picture.
first, I have to tell that I know only the basic fundamentals of access.
I have created a basic access form to enter my client's data and their contact details. so there are two tables. When a client comes I have to enter his details in the main form and I have to enter the service why they came to me in the subform.
now my question is, ones I put their details to the form if they come again after a few months later how can I update same profile since CLIENTE ID field is auto number. because I want one profile and multiple contracts.
pls, refer attached picture.