Adding Column From Another Table

[rob51852]

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

 

[Micron]

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]

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]

Thanks for your replies. I’ve managed to work it out