question about copying a record with subforms assocciated to it

[CFP - Jason]

i have a table that holds all the customer info to make a work order. there are quite a few subforms that are datasheet associated to that particular record. when i make a work order, i want to save it some where else so that i can go back and look at the work orders like year later. how would i go about doing that? i want to be able to view it from that particular customer, so i guess is has to be stored with relation to the customerID. so really i wanna use the interface i have now to make the work order. then press a button and the work order is made and saved for viewing/editing later.
Any help is much appreciated, i have hit a wall right now.
Thanks
Jason

 

[jfgambit]

Jason:

If your database is normalized correctly, you should be able to create a query that will pull all the infomration based on a CustomerID, Invoice ID or by a Invoice Date. You can create a query that will filter that data from your tables and open a report or an invoice where you could review historical information. You do not want to create an additional table to store data you already have in the database. This moves away from Access Database Normalization and could potentially increase the size of your database to a size that can not be managed easily.

Access has a Invoicing DB wizard that you can set-up on your computer and look over to see examples of Historical Queries and Reports.

I know I have not given you the exact answer, but I hope that that helps put you in the right direction.

 

[CFP - Jason]

i dont really understand when i run a query, where does it get the history from? if i dont store it somewhere how can i find a work order from last year. right now its just in a table for the current one. but if i make a change then the old info is gone. i think i just dont understand how that works.
Jason

 

[jfgambit]

Jason:

What are the tables and fields that you have in the database?
Can you post a zipped example of the db?

 

[CFP - Jason]

um, im goin to have ot make a stripped version of it so u can get what i mean. im gonna try and see if i can break it down.
Jason

 

[CFP - Jason]

ok i have one u can look at. how do you like me to send it, i dont wanna post it, it has company stuff in it etc.

 

[jfgambit]

I just sent you an e-mail

 

[CFP - Jason]

it bounced back to me, so ill pm you a link
Ok real quick ill run you thru the steps to get where I mean.

-find customer

-by company name

-double click “Test Company”

-goto jobinfo tab

-and there it lists the specific services for that comp (double click to view), now that’s a one shot deal I haven’t put in that version yet ,but it makes a workorder in a report. Now that I need to figure out is how to save the work orders so that I can retrieve them later. The one that u open is like the template, thing will normally go like that but sometimes employees and cost etc change per time. How can I keep track of the jobs from the past and keep all the data from all those sub forms?

Thanks a bunch

Jason