CPT Album
— – Album
| – Artist
| – Length
| – number of title
| – genre …
|
| CPT Review
| – Title (Review sentence)
— – Album
– Artist
I’ve got a one to many relationship between CPT Album and CPT Review wit the field Album
I want the field Artist to be automatically updated once an album is chosen in the CPT review