New to access - information needed

[Joshinkii]

Hello,

not sure what I should be searching to find something below as an example/tutorial

So wondered if anyone could point me in the right direction..

Thanks

#######################

+tblAgenda
Number|ID Date|Time Text|Agenda
1 10am Promotions
1 11am Images
2 10am Promotions
2 11am Images
3 9am Fonts
3 10am GUI


+tblJobDatabase
AutoNumber|ID Text|MeetingName Text|Comments
1 Meeting #1 Discuss Microsoft
2 Meeting #2 Discuss Google
3 Meeting #3 Discuss MSWord


+frmMain
+Split Table underneath

As i change my records on bottom based on JobDatabase when record [1] is called
In the split report I want it to show

Meeting information in text boxes above
and
Table underneath showing only agenda for [1]

and when I change record on frmMain it will change accordingly ie, [1] or [2]

Do i need to use some sort of query and link it? any tutorials or information will be much help.



PS- Sorry if this is in the wrong area.

 

[jdraw]

I think the reader would get a better appreciation of your issue/request if

you were to overview your situation in plain English just as you would to someone in a line up at McDonalds who knew nothing of you, Access nor database.
What would you say in the simplest terms possible?

 

[Joshinkii]

Sorry i just thought it would of been enough info.

Only way i can explain is i would like a table to appear on a form that will show the agenga table for that id record im currently looking at..

So if im in formMain looking at record 1, i want to see the agenda of record 1

Hope this helps with you assisting me.