Looking for help with cross Table lookup

[fleutius]

Hello there. I have run into a bit of a situation with my limited knowledge of Access 2013.



I am sorry if the post is in the wrong part of the forum, and if my explanation is missing information

Firstly an explanation of the current database setup:
I have two Tables, DancerT and ClubsT.
The database is used from a Menu form, and all data entries are made in a form that lists only one record at a time.

DancerT is the artists that we currently work with. I would like to be able to go into their records, and select, what clubs they have shown interest in.
Best case scenario, is that i can select clubs from a list that updates itself from what club records I have in ClubsT (possibly with the possibility of filtering from other parts of the record)

Then when i go into ClubsT, it would be possible to view a list of all the dancers that have shown interest in that specific club.

I must admit that i am in no way very good at using Access, but i am learning as I go. Until now, i have only made use of built in functions of Access, and not done any real coding
Thank you for any help given on the subject.

[Homegrownandy]

You will need a junction table to show relationships between the two as a new record. So your Dancer ID and your Club ID with be the values in this new table.. Along with the ID of that specific record.

It will look like:

Relationship ID..:..Dancer ID..:..Club ID

1..:..1..:..1
2..:..1..:..2
3..:..2..:..1

this shows dancer 1 shown interest in club 1 and club 2. dancer 2 shows interest in club 1. and so on....

The way you/users view this on the form. (from the query) will be their details such as the name or whatever you want so don't worry if it seems confusing. It really isn't.

Once you understand this concept or if you have any questions let us know and we can move forward setting up your querys.

[fleutius]

Thank you ever so much.

The simple fact that you mentioned what that function is called means that i can now go find several tutorials on it. And it seems that my problem is much easyer to solve than i first thought.

One of my biggest issues in this whole affair is that i dont allways know what the different aspects of Access is called, and therefore have problems finding help for it.

Once again thank you, i will study this area a bit, and then see if I can solve the problem

[Homegrownandy]

Yes I have the same problem quite often. No worries mate.

[fleutius]

Happy days, it worked.

both on my club and my dancer registration forms now show the correlating info. Thank you for the help once again

[Homegrownandy]

Not a problem.