Dear reader,
Thank you for your time in opening this thread to start reading my query.
I am building a small customer database access app for my fathers friends business. The database is to keep a record of 'clients' (business names, addresses etc) and the 'customers' (people names, email addresses etc) who are the people that work at the business.
In order to keep my question as simple as possible I hope it's okay that I share screenshots as I am a beginner with MS Access.
Below is the Home page.
Screenshot below of View All which is the 'Clients' table.
Once the detail button is clicked it opens up that particular 'clients' ID as per below.
This is where I need your help in answering my question, please! I have created a table named 'Customers' which stores the information of the people that work at this particular business. When the people button is clicked this will lead to the page as per below.
I have manually added myself 'Greg Owen' to the customers table which at the moment this list will list all people work are within the database. I want to add a button of add new which will take the user to a form which they can capture the details of a person working at as per our business example Province Lighting. How do I ensure that the person added is directly linked to this specific business ID only?
Any assistance would be appreciated please.