Custom CRM scripts

[bullet_proof_eejit]

I'll try and describe this as best as I can without all the un-necessary extras. I'm building a small database to contain customer information and some notes but the important feature I want to add is the ability to book adverts in a magazine. I have several tables linked by serial number and things seem to populate correctly.

There are obviously multiple magazines over time so I created a table with magazine details in and linked this to advert booked. So the table with the relevant info in links customer and magazine together.

Basically I want to be able to create a report which shows all the adverts for one specific magazine. So to cut a long shorty short I would like to choose a value from one record and sort on another table with only the relevant data showing.

Any ideas?