Adding Column From Another Table

rob51852

Board Regular
Joined
Jun 27, 2016
Messages
81
Office Version
2016
Platform
Windows
Hi,

I'm trying to devise a query to add another column of data from another table.

I'm an Access beginner and am getting myself tied up in knots.

In plain English, I am trying to use the bowler ID in the BallByBall table to insert a new column with that bowler's bowling style from the Lineups table. In the Lineups table the bowler's ID is called playerId. See below. There will be many occurrences of the bowler ID and the playerId.

If anyone can point to how I can do this it would be appreciated.

Thanks

Untitled.png
Untitled1.png
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
1,806
Not clear what you mean. Insert where?
You'd typically join related tables in a select query. The join(s) would be between fields that are common, and you'd use that query as the recordsource for your form. If that is player ID, it is not good design to call it PlayerID in one table and something totally different in another table as it seems you have. More like PlayerID > PlayerID_fk or PlayerIDfk (fk = foreign key). Some will also put PK in the primary key field. A year later, it's obvious what is what. Also, you don't repeat fields and data (other than related fields so that they can be joined in queries) as it seems you are doing. It's not good normalization practice. You are repeating match id, plus it seems you want to repeat bowling style as well. I think you'd do well to read up on normalization and compare what you learn to what you already have.
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,603
Office Version
2013
Platform
Windows
In plain English, I am trying to use the bowler ID in the BallByBall table to insert a new column with that bowler's bowling style from the Lineups table. In the Lineups table the bowler's ID is called playerId. See below. There will be many occurrences of the bowler ID and the playerId.
What exactly are you trying to do that you are having trouble with? Are you trying to write a sql query? Or create a form?
 

rob51852

Board Regular
Joined
Jun 27, 2016
Messages
81
Office Version
2016
Platform
Windows
Thanks for your replies. I’ve managed to work it out
 

Forum statistics

Threads
1,089,637
Messages
5,409,464
Members
403,265
Latest member
HMR120

This Week's Hot Topics

Top