March 1, 200619 yr Newbies 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?
Create an account or sign in to comment