One-to-Many Relationship (2003)

Topic

New Reply

I have several tables I need to join, or some how make a relationship with to make a query and ultimately a report. I’m not sure what to do. I am a realtively new user. I put the cart before the horse and created a form that I thought I could use as my printout but I can’t get it to page break before each new record. Can I somehow convert this to a report to print it out?

Any suggestions would be welcome.

Reply | Quote

Replies

Monica,

I would start by creating a query with the information that you want on the report. In order to join all the tables, you need to identify what information in each table can join the two tables together. Once you get that done, you can use the Report Wizard to create a report — you can play around with the variations.

If you like the form, you can simply highlight it and on the Menubar, chose “File->SaveAs,” and chose, “Report.”

However, I wouldn’t recommend that until you successfully get the data that you want to display, successfully tied together.

There are a lot of local businesses offering 1-day classes for beginner, intermediate & advanced users, and I would strongly recommend that. Not only are you doing yourself a favor, you are doing the economy a favor, if you or your business can afford it.

thx
Pat

Reply | Quote

Just as an add-on the what Pat suggest about training, you should also check local colleges and junior colleges. They often have special training classes that require less time commitment than a full course (although that isn’t a bad idea). Often they will have something like a Business Development Center that offers such classes (maybe on a weekend) primarily aimed at business people.

Reply | Quote