How can I get Data to pull from a table and show in a form?

[KingOf206]

Ok, so i am beginning to build a very extensive database, RIght now there is some random "test data" in their to practice with. To give some background on what I am trying to do..



I am trying to build a database where I can manage clients and events. I will be creating and hosting events and will be having new clients signing up to go to these events, sometimes i will even have returning clients as well. I will also have employees as well. I am trying to organize this data so i can manage it easily. That way when i have a new event, I will be able to select the event and then add the clients who have signed up for the event with ease ( i have not yet added the "ADD NEW CLIENT " feature, will work on that later).

My question is regarding a form that i have Called "Frm_Organized events" I am trying to have this form be my main form as I will have already entered the "event information such as Location, date, etc. My first issue I am having is that I am able to successfully pull in an event using the combo box, however when i try to add a another box that I would like to pull the date that is ASSOCIATED with that specific event, it make sit so the entire form is blank when i go into the 'Form view"

How can i make this form pull data that I already have entered using my above example?

I have inserted a ZIP of the database I currently have explained above. ANy helpful advice would be greatly appreciated.

Events-Database - Copy.zip

[orange]

My recommendation is that you work through some tutorials on Normalization and database design.
There are some good tutorials at Rogers Access Library --you have to work through them to get the benefits, but what you learn can be used with any database. Work through a few of the tutorials listed below to understand design. Getting tables and relationships designed and vetted to support you business is the most critical step in database development.

Start with a clear description to the business issue you are trying to resolve or automate.

Here are some tutorials:
http://www.rogersaccesslibrary.com/T...lationship.zip
http://www.rogersaccesslibrary.com/T...nformation.zip
http://www.rogersaccesslibrary.com/T...erItDesign.zip
http://www.rogersaccesslibrary.com/T.../GSADesign.zip
http://www.rogersaccesslibrary.com/T...cripDesign.zip
http://www.rogersaccesslibrary.com/T...getsDesign.zip

Good luck.

[June7]

Is this what you need http://www.allenbrowne.com/ser-62.html

Have you looked at MS Desktop Event Management database template?

[KingOf206]

I saw that example template when i started, by it would seem that my database is going to be a bit more dynamic. It would include

-the list of clients
-ability to add new clients
-list of event locations
-add new locations
-add employees
-etc

It doesnt seem at first glance that i could just use that one since i want to make reports of each event and whos supose to be attending, that way I can check people in and know who didn't show up. and other info...


**Also the link you provided, i dont see in there where it tells me how to show data on a form that is populated from selecting a combo box on that same form. For example, if I chose a specifc event, and I already have that event saved (with a date for the event) in a nother tablem when i use a combo box to add a client to that event, i should be able to add a "city" field that auot-populates with the city that correspondes to that event.

I didnt see that in the link you sent.

Is this what you need http://www.allenbrowne.com/ser-62.html

Have you looked at MS Desktop Event Management database template?

[June7]

Why are event host and event assistant and event date duplicated in Tbl_Events and Tbl_OrganizedEvents? Just save the EventID into Tbl_OrganizedEvents or the reverse, ID from Tbl_OrganizedEvents into Tbl_Events.

Why are you including queries in the Relationships builder? Never seen this done.

Why is Tbl_EventLocations related to both Tbl_Events and Tbl_OrganizedEvents. http://www.codeproject.com/Articles/...atabase-Design

Why is there a Gender field in Tbl_OrganizedEvents?

You really need a better understanding relational database principles. Suggest you study the tutorials already referenced.

[KingOf206]

OK, thank you both. After reading your advice i decided to start over. I have re-structured my tables. I have posted what i have here:

https://www.accessforums.net/databas...tml#post295648

If you can please give me feedback on how it looks. I am at a road block atm, and cant seem to get the relationships between my tables correct. I posted an image and a basic excel file so that it can be viewed by all and if someone make edits to my excel file to show me what im doing wrong.


Again, thank you for your help and I look forward to hearing feedback of all kinds.