Taking Form info and putting it into a Report

[MrDoritos]

Hi all. I'm new to the whole Access thing so please go easy on me.
I'm tring to create a DB that will be used in a dog grooming/boardind kennel. I have four tables so far. CustomerInfo, DogInfo, GroomingInfo, and BoardingInfo. Now I've set up forms that will let me input the customer information, along with the dog info for that customer. How should I set up the info for the Grooming and Boarding forms. Relationships are set up using a customerID and a dogID but how do you have the form call up a certain customer with their dog into the boarding or grooming form?
Second Question: Once that information is input into the form is there a way to send only that info to a report that can be printed, without displaying all customers and their dogs.

Again sorry if this question sounds incomplete as I am not really sure what the hell I'm doing.

Thanks in advance,

Dave

 

[LonnieJohnson]

Question 1: What information pertains to the grooming or boarding? What relationship to the data does it have? I would suspect that you would want to link the boarding and grooming tables to the DogID. That way every customer will have a dog or multiple dogs. Each dog will have a grooming or multiple grooming records as well as boarding records.

Question 2: To get a report of one customer, you will need to set up a query that will pull the customer and/or dog ID from your form and use that as the record source for your report.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[MrDoritos]

Yes you are correct with question 1, the grooming and boarding data is linked via the dogID field, and of course customerID is what links the customer to the animal.
There will be multiple records for both the grooming and boarding. The information that I want to show in the report would be some of the customers info, the dogs name, and previous boarding or grooming info. Setting up the query is where I have the problem. I would be greatful for any help via examples anyone might have.

Thanks again,
Dave

 

[lespaul]

What kind of problems are you having setting up the query?

If you need some basics on query's, google for online SQL tutorial.

Otherwise, in Access, open up the Query Design view, select the tables you want to include, select the fields you want to include and Access actually writes the corresponding SQL.

Leslie