Look up reference number in seperate table

[Kalina]

I have two tables. I've listed the fields that relate to this question.

Table:Artwork

Fields: Description, Scene

 

Table: BG Reference

Fields: BG Name, BG number

 

 

BG Reference has a value list for BG name that gives me any related values from Artwork::description

 

I would like to have BG Reference::BG number look up the Scene value that corresponds with the value in BGName.

 

Please help.