Hello all, I'm fairly new to Access but I've been working hard at learning it. I appreciate any help you guys can offer. You have an amazing forum here, and I've already found it invaluable to my Access learning.
I’m working on making a fairly simple automotive repair order database for a friend who is using some very old/legacy software and is now having issues. I'm uploading my DB, I've scrubbed it, for you to have a look at. I’ve created a search form (CustomerSearch) that works and displays the appropriate info, as well as a Repair Order form (NewRepairOrder) that I’m able to fill out and works appropriately.
My problem is I’m not able to use my Repair Order form to create a new RO (Repair Order), I'm stuck. It’s data source is a select query, which works great for editing an existing RO, but not creating a new one. I can use the search form and select one of the top two customers, that I’ve manually created an RO for, and click the Open R.O. Button on the search form and have the RO form open to the correct Customer and RO, which I can then edit. But if I select the third customer in the search results, who has no Repair Orders created for them, I can’t figure out how to open the RO form using this customers CustID (to populate their address, phone, etc) and create a brand-new RO for them. I was thinking I needed to use an append query to create a new Repair Order for the customer and then pass that new ROID onto the form, but I’m not sure if that’s the correct solution and how to do that.
I’ve tried to normalize this DB as much as possible so my Customers table is joined to a RepairOrders table and a Vehicles Table. RepairOrders is joined to tables: Labor, Parts, ContractLabor, etc.
Thanks again for all your help!
I’m working on making a fairly simple automotive repair order database for a friend who is using some very old/legacy software and is now having issues. I'm uploading my DB, I've scrubbed it, for you to have a look at. I’ve created a search form (CustomerSearch) that works and displays the appropriate info, as well as a Repair Order form (NewRepairOrder) that I’m able to fill out and works appropriately.
My problem is I’m not able to use my Repair Order form to create a new RO (Repair Order), I'm stuck. It’s data source is a select query, which works great for editing an existing RO, but not creating a new one. I can use the search form and select one of the top two customers, that I’ve manually created an RO for, and click the Open R.O. Button on the search form and have the RO form open to the correct Customer and RO, which I can then edit. But if I select the third customer in the search results, who has no Repair Orders created for them, I can’t figure out how to open the RO form using this customers CustID (to populate their address, phone, etc) and create a brand-new RO for them. I was thinking I needed to use an append query to create a new Repair Order for the customer and then pass that new ROID onto the form, but I’m not sure if that’s the correct solution and how to do that.
I’ve tried to normalize this DB as much as possible so my Customers table is joined to a RepairOrders table and a Vehicles Table. RepairOrders is joined to tables: Labor, Parts, ContractLabor, etc.
Thanks again for all your help!