I am currently volunteering in Tanzania with organizations that support the rescue of girls who are facing GBV, Forced Marriages, and child pregnancies. One organization asked if I could help them setup a database to track their customers, their equipment, their training, and employees. Fairly straightforward I thought but then I got trumped by some processes that need a little more code that I know.
My plan is to have a welcome form that starts on opening the database [completed] and have a Customer form [read only] to view all customers with an edit form to edit customers details and add/subtract equipment and training.
The customer form [SIDOSMEs] contains all the customer data and a tab control to view the equipment, training, and employee's sub-forms. [EquipmentSubform, TrainingSubform, and EmployeesSubform].
I have a SIDO Equipment form where we can add SIDO made equipment into the SIDOEquipmentSubform to track equipment specific to SIDO. On the EquipmentSubfom, I would like to be able to type in customer equipment specific to the customer as well as add SIDO equipment purchased by the customer.
I have a SIDO Training form where we create classes that the customers will take kept in the SIDOTrainingSubform. I would like to be able to add a class to a customer, keep a tally of how many customers are assigned to each class and only be able to add a particular class to a customer once.
Employees data is basic and working properly in accordance to SIDO's requirement.
I have tried setting relationships, creating junction tables, even tried using union queries and nothing is working properly. I can admit that the problem might just be I have tried to many attempts and didn't properly remove those that didn't work or it might just be that I do not fully understand the coding required to complete the tasks, I am not a programmer but I didn't think this database would have been beyond my basic skill level.
I am able to pay for someone to help me get past these hurdles and get the database functioning, any support that can be offered would be greatly appreciated.