Hi Access gurus,
please excuse my raw subject, fact is, I dont even know how to summarise what I am asking.
I am a complete access beginner, only done a few full courses online, skillshare, and YouTube and I have started to build a basic carwash management system for my carwash.
Basically there are 3 categories/tables.
1)Customers
2)vehicles
3)job cards
The customer table has the basic details of the customer, and I have a form and dashboard where you can crud the customer details and search for customer using either their, firstname, lastname, or cell number.
The end goal is to be able to add vehicles that are "Attached" to a customer, because each customer may have more than one vehicle that they bring to the wash. So I want to include a filtered subform that links to the vehicles table, within the customer form, to show us what vehicles that specific customer has. Question is, how do I filter the specific customers vehicle to show within the subform and second question how do I allow adding of the new or additional vehicle and attach it to a customer which is located in a different table.
I'm not sure what to use a Unique identifier that we can filter for the customer.
So when a customer arrives, the supervisor will open a new job card, select the customer, which will use a combo box to search and auot populate the customer fields within the job card, then select from a drop down list, the customers vehicle, and then select the services and continue with the work.
My issue is attaching a vehicle to a specific customer.
Please kindly let me know if I'm not making sense and assist if you are able to with as much information as possible, seeing as though I'm quite a n00b at this.
Thank you in advance, hope to get some great solutions!