Help with an Access Database.

[Josh Hambright]

Okay so one of our programers/IT kids wanted me to post this up here.

He is reworking out scouting database so that not only does it have robot information but also it will have match info and have them both all linked so we can see a robots info and everything.

So his question is:

How do you in the code search through different tables and collect data from each entry.

Like if we enter the team numbers in a match and their scores. How do when then display on that teams information what their scores for each match and the match numbers and their avg and everything nice and pretty like that?
Also how do you access one form's data from another form?

[yruhere]

I'm confused to what you are asking..

If you have a row for each team, you should just be able to search the column with the team number that you want and you would have all the info in front of you. I hope that helps.

[Jferrante]

Microsoft Access has the capabilit of doing what you are asking if I understand you right. You can create multiple files, each one containing certain information about the team. Then using the team number as the common object to organize the information by. Unfortunately I don't know how to put that onto a webpage.
Hope that helps. Good luck

[Stephen Kowski]

You can just have extra entires in one table and have an QUERY update the other values as you get them in. Dunno if that helps.....