Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Help > DevNet >
Back to Access Developer Network    Comments List
multi form DB issue Upload Images   Link   Email  
James Harvey    
5 months ago
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.
Jennifer Neighbors       
5 months ago
Hi, James -
I often work on databases for nonprofit charitable organizations on a pro bono basis and I have some availability. Please contact me if you are interested in ongoing support for your project. Send a message to [email protected]. I can help!
John Davy           
5 months ago
Hi James,
From what I understand, it sounds like you are having difficulty with the training classes. Is that correct? That will probably require a many to many relationship for each person may take many classes and each class will have many people, so you will need a third table which ho;ds the key field from each of the other 2 tables. I have a demo that you can study and or use to understand exactly what you need to do. if you send me your email I will send it to you. [email protected]   John

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Network.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/14/2024 11:51:37 PM. PLT: 1s