multiple tables per person (student)

[mickelingon]

Hi

I have a DB for students.
I'm making notes each time we've had a chat.
Is there a possibillity to make a relationsship between 2 tables so I can make multiple records for one person? (or any other way)
For ex. 03-04-06 there were a couple of things I wrote down.
and 03-06-06 there were some other things I wrote down about the same person.
and then I will be able to backtrack this information
How do I do this.

Mikael

 

[lightray]

I would have a Students table, each student would have StudentID (autonumber) You would then want a Conversations or Chats Table
This would also have a ChatID (autonumber) a Date Field and StudentID and Conversation. A topic field might also be good in here.
In the Student table list all things about Student.
Link StudentIDs that should pretty much get you going
Then you can run a report on a Student and pick out all the conversations.
lightray

 

[mickelingon]

Sounds great, is there a possibillity for you to make a quick example I can use as a template.
I know it's kind a rude to ask but I can't get it to work!

Mikael

 

[mickelingon]

this is how it looks

I would like to have the dates and comments in the subform.
You can for example type in lar in the textbox "efternamn" and hit enter and I will be able to make comments for this person.

//Mikael

 

[lightray]

Sorry, cant do it right now, no MS access here. perhaps tomorrow
lightray

 

[mickelingon]

It would meen alot to me.
When I open the form I get this enter parameter value to insert date.
I would like to skip that and have a combo box where I can choose date from or just write it in a textbox.

Thanks in advance

Mikael

 

[lightray]

Hi Mikael,
Sorry I have had an urgent project on. Are you still needing help with this?