Search results

Ok, I got the combo boxes to work... Now for part too... Once I select the Event in the 2nd combo box, I want that to populate all the fields on the form, according to what that event had. So I I select the date, then the event on that date, and all the information populates...

Ok, I have 3 tables, event, person, and personat event... I have a junction table linking it all .. . All that works, Currently I am working on an formUpdateEvent. I want to start out by choosing the date of the event, cboDate (I need the date to be selected from DetailDate...

Thanks got it working.

Also, which form would I put the Add Record button in? the main form or subform?

First off, thanks for your assistance ahead of time. I am creating a database for Jobs(event) and who goes on each Job(people/person). Currently I the following tables tblEvents (EventID Primary key, Autonumber(this way it makes it for me)) tblPeople (PersonID Primary Key...

OK, So I have the 3 tables, I have the ID(eventID, personID...) in each as the only Primary keys for these. I have relation ships like I posted above, eventID-eventID... Now I am creating forms. I created my formAddPeople first, as I figured I need people inorder to populate...

Hum.. Every where I read told me to make them a "Compound or Composite Key". Ahhh why is this so difficult. OK, so if they are not compound keys, will it still work correctly? I don't really understand what the whole key thing does for them.

Access 2007 Used. Ok, So I started from scratch and deleted all my forms and everything. I currently have the following tables tblEvents (EventID Primary key, Autonumber(this way it makes it for me)) tblPSNL (PSNLID Primary Key, Autonumber(Same reason)) tblPSNLAtEvent (PeopleAtEvent...

WOW .... super nerd joke! but funny..

Add these together in your head, then write down the final answer.... then use a calculator and see if you got it correct... 90% of people don't 1000 + 40 + 1000+30+1000+20+1000+10

Semi beginner, Hi all, Ive done a little with basic database design and forms, but I am trying to complete something right now that I seriously need help on (will post in correct sections).

I want to try and use a junction table, but .... jeeze once I get the relationship, i don't know how to get the forms to populate the junction table properly or anything... I feel so stupid. Anyone have a everything you need to know when using junction tables?

Nice, thats a good deal!

Thanks Both thats very helpfull, hopefully I can figure this one out.

Humm, Do you have a simple example you can upload or something, I just ain't getting it... .... What I am understanding is, Column 1= People At Events, Column 2=Person ID, Column 3=Event ID... Row 1 = First event Row 2 = Second Event Row 3 = third event Each row, being populated...

ALSO, I was wanting to be able to put what each person does at said event, So Event 1, "john" was the locksmith, bill was the fire fighter(not real jobs hehe). ... Would this be possible with this junction table process?

Humm... I have never done one like this, Would you still be able to pull reports by individuals? Meaning, what did SO&SO do from date to date, and all the events with times/hours/miles come up? And how would the people at events table work? Rows= events &columns =people.... Also...

First thanks, Summarization ...I want to create a form, that in-turn populates a table and creates another table (using a template, and being named with one or more of the textbox information). Ok, So I am planning on creating a database that tracks personnel and events. I need to...