Display in a form multiple results

[webisti]

Hi I am creating a database with players and teams. all saved in one table Participants
I am creating a form where by choosing the team number it would show in two separate sub forms (not necessarily) the profiles of the players for that team.
Do you have any ideas on how to do that?

Regards

Webisti

[ItsMe]

Hi I am creating a database with players and teams...

If I make assumptions about what a player is and what a team is I would suggest these two entities deserve their own, separate, table.

If it is all in one table, I suppose there is a field that describes the team. You could use this field within a WHERE clause to retrieve specific records.

[webisti]

There is a team ID actually. So by selecting the team ID the coach can compare the profiles of the players.

[ItsMe]

There is a team ID actually...

This sounds like there are two tables and "team ID" is a Foreign Key to the PK of your Teams table. This would be good.

Include the team ID field in a query. You can use the query builder to aid in creating WHERE clauses. Add criteria to the grid towards the bottom of the window while in design view. Use the appropriate field.

[webisti]

In order to have a clearer view here is the db I m trying to create with the player comparison:

SAMPLES.accdb

any help would be appreciated.

regards

Webisti

[ItsMe]

I looked at your DB and I am still not understanding your objective. I think there are serious issues with your approach having only one table. However, you may be able to accomplish what you want by building a subform and linking your Main/Child on the team field. You could base your Main form on the table and your subform on the query, editing the query where needed.

For more info on table structure here are some tutorials.
https://www.accessforums.net/tutoria...ase-45451.html

[webisti]

basically it is a comparison table for viewing the players. Nothing more. The team Id is the as a key but contains two players max.
What I want is that in the form by selecting the team id the coach can see the profiles of both players.

[ItsMe]

...What I want is that in the form by selecting the team id the coach can see the profiles of both players.

Try implementing a subform.

[webisti]

Already trying.. will let know if it works

[webisti]

So far unsuccesful to do it as i wished.

[webisti]

anyone tried to look at this? I am not so often using access therefore sometimes get lost.
any help on using the db as a sample would be greatly appreciated.
regards

Webisti

[cbende2]

I tried to do what you said, let me know if you need more help.

SAMPLES.zip

[webisti]

Hi Cbende2
cannot open you attachment

[webisti]

Ok I did checked it but still is showing the same player twice and not a single player per text form.
What I wanted is that when selecting the team both players would appear. two different players beside each other,

[cbende2]

It's not showing the same player twice, check again. And I'll try to make it appear side by side.