I have this Table which has many fields & I’m trying to breakdown this Table into 2-Tables, however I cannot get them to join in a query.
Here is some of the Fields in my 2-Tables:
Table 1: Series Results
- SrsRsltsID
- OwnrsID
- Srs (Series)
- RcWk
- Start
- Finish
- CrTrck
- Rookie
- Driver
- Make
- Sponsor
- *I use to have my “Owner” field in this Table, but I want to make a separate Table for the “Owners” which corresponds with the “CrTrck” Field.
Table 2: Owners
- OwnrsID
- SrsResultsID
- Owners (The Table is blank/has no data)
In a query I tried taking the “Srs” & the “CrTrck” fields from the Series Results Table -&- the “Owners” Field from the Owners Table, but I get nothing in return.
My objective/goal is to only need to type in the Owner correspondent to the CrTrck once vs. for every record as I’ve been doing.
Any help would greatly be appreciated!