Hello all,
I am trying to find a solution for editing and deleting fields with my current access project. Currently, I can open frmTickets and enter data, but there are a few pre-requisites: one being tblCustomers and tblEmployees need data in them to pull from.
That part is fine even with the pre-req's. The issue is when a user needs to edit or delete an existing ticket. The only way to do that is to first delete the devices associated with the ticket (tblDevicetoTicket), then delete the ticket itself (tblTickets).
This is obviously not ideal but the requirements were to have multiple devices mapped to a single ticket and to be able to report on them.
One solution, I thought, was to add navigation buttons to the frmTickets but it has combo boxes based on queries as well as a subform and I haven't been able to get that to work.
Does anyone have suggestions? I've attached a stripped down but functioning version of the database.
Thanks for any help!