Creating query to produce report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Myself a novice user. I am building a databse and one of the elements is a
form designed to look like a programme card for my Personal Trainers to write
a bespoke programme using a number of combo drop boxes, so they can choose
exercise, reps, sets and so on. The data for these combos is kept in numerous
tables which store the variables and exercise descriptions. I need to now be
able to print this info in a report and i presume creating a query would be
the best way as if I try to print using table data all i get are the ID
numbers on the report. With this in mind do I have to have a relationship
from EVERY table carrying data for the variables on my 'progcard1' table so
it can reference the Variable IDs and give the text description rather than
numerical IDs. If so is there an easier way than having to add numerous new
fields to the progcard table and renaming them all chestID, backID and so on.
I also have trouble with Access telling me changes or deletions cant be done
due to them being related, but I cant see them on the relationship windows.
Where are they linked so I can delete and amend problems??? Thankyou for your
patience!

Paul
 
Back
Top