Select info from form to form

[Glock232]

Hi gang, first post here. I consider myself an intermediate PC user and Beginner/Intermediate Office user. Of course im sure ill get blown away by some of the advice / ideas on here and learn more than I ever thought and feel like a total Newb...

Anyways.. my problem.. I need to track some information based on.. .

1. Event: Date and Lengt in hours
2. Attendees to specific event and hours they were there
3. I need to be able to add multiple attendees to events from a Member table..

Basicly im with a rescue squad, we need a better way to track who attends what meetings and drills and fund raisers.. I have been toying with things for weeks and cant get this DB set up the way I want to. I need to add all the members to the DB, then as they occour I need to add Events. When I add the events I need to be able to choose multiple persons from the members table. and submit all that data and have it record the info for each person.

Best example I can think of to describe exactly what I want is if you search MS online for the "Book Collection" database, the way you can add authors to books is what I want to do.

Hope that is a clear description of my issue..

Thanks
Joe

 

[TheAceMan1]

How are ya Glock232 . . .

Your first order of business is getting your tables and relationships in order. No need going any further until this is accomplished.

To get started I suggest you work your way over to the Microsoft: Access Tables and Relationships Forum and repost there.

At your leisure have a look at the following so you have a better understanding and can better relate your needs:

Fundamentals of Relational Database Design

Normalizing Tables

Table Relationships

You'll find its a bit more than you thought!

See Ya! . . . . . .

 

[Remou]

How about thinking of Events as Orders and people as Order Detail and then having a look at the Northwind sample database to see if it can be modified to suit?

 

[Glock232]

Good Idea Remou, I tried a few different "templates" online and haven't been able to modify any of them successfully, but I'll play with Northwind and see if I can do it that way.

and TheAceMan1, Ill copy/paste this over there and see what kinda replies I get while im messing with Northwind.

 

[Glock232]

Ok, I tried quickly to modify Northwind, but gave up on it for now my brain is fried... BUT... if you open that DB up on the switchboard, if you click "Orders" that is what im looking for but to simplify....

Members Table : ID#, LastName, FirstName
Events Table: ID#, Date, Type (from drop down list) and Description..

Then I want to make a form to 1. Enter Members (which I think I have done right)

Then I want a form to enter a new event, and have it give me a pull down box with members names just like order detail in Northwind... I dont know what im doing wrong, maybe im not telling it to look in the right table for info?

 

[TheAceMan1]

Glock232 . . .

Be sure to take a look at the [blue]relationships[/blue] in the Relationships window (Tools - Relationships) for the connecting tables in reference to the orders table! . . .

[blue]Your Thoughts! . . .[/blue]

See Ya! . . . . . .