Relationships & Tables

[amature_access_user_84]

I am creating a database for our youth sports club and running into issues with my relationships (or at least I think that is where the issue is).

tblPlayerNATWE (This table has all the basic PlayerID (primary key/auto#), Name, Address, Phone, Contact Info for the players. This is the "main" record as this generally won't change.)
tblPlayerSeasonData (This table has the season year, PlayerNATWE_ID, team information, jersey size, etc. This is the data that changes every year as they are on different teams every year and their uniform sizes change every year.)
tblPlayerPayments (This table has the season year, PlayerNATWE_ID, payment date, payment amount, etc. This is the data to record their payments for the year, each season.)

I created one-to-many relationships with tblPlayerNATWE and the tblPlayerSeason Data.

I created one-to-many relationships with tblPlayerNATWE and the tblPlayerPayments.


I am trying to create a query that shows me the financial information:
Player Name
Address
Phone
Season Year
Payment Date


Payment Amount


When I build the query and insert the two tables and the desired fields, I get the error: Type mismatch in expression.


Any thoughts on what I am doing wrong?

[NoellaG]

Hi,

if tblPlayerNATWE.PlayerID is an autonumber field, than the corresponding FK field tblPlayerPayments.PlayerID should be a numeric field type long integer. If that is not the case, you can post a sample database, so we can have a look at your tables.

kind regards
Noëlla

[amature_access_user_84]

Wow...so simple. Thank you so much. That worked.

Now I can quit banging my head against the wall and move on.