You have chosen to sponsor your bid up to a maximum amount of .
We need to create few forms in MS access and store the data in it.. In this project, forms will be related to each other. We have following forms
1) Event 1 form
2) Event 2 form
3) User/contact main profile form
4) User referral form [ this form is attached as a tab to ' User/contact main profile ' form ]
5) User current situation form [ this form is alsoattached as a tab to ' User/contact main profile ' form ]
The idea is you have contacts/users and you have events.. Contacts go to Events, but they can also just be contacts without going to events. Each Contact should have the Main Profile, and then a Tab with Current Situation, Referral form, and Events. On the Events I would think it would just be a list of event forms that contact has filled out. ( so I would think it would just be a query box that queries the users events) Also we would need to be able to open up those events from that Contact Events tab.
The Events, are going to be the forms below, I would think if you are choosing add a new event, you would choose Event 1 or Event 2 as the different questioning, and then we could enter in Title, Date, Location and Category for each event. Those should be auto-populated, so if one time we have entered 'High School' it would give us the option if we start typing "high" to choose whats already in the database for High School. This type of auto-populate would be nice to have in the whole database, especially the user names, categories, and referral comments.
Please find the attached excel sheet for form fields details and more information