Save Report

[cmfog]

I have a form that has multiple tabs and once I fill out the form I have all my information sent to a report. I am trying to save the information for each report so that I can come back and edit information on a report if I need to. I am not sure how I can do this

 

[BlueIshDan]

Why not actually store the data into a couple tables?

 

[cmfog]

I have two tabs and the first tab is a table where that information is saved and then my second tab is a subform which is made up of a combo box that pulls information from a table and then a list box that allows me to choose items and then sends the items that I selected to the updated query. I think all I need to know is how to link the customer tab (the first tab) to the items tab (the second tab)

 

[BlueIshDan]

I mean do you have actual tables in your database or are you storing this in memory during runtime?

 

[cmfog]

I do have tables. There is a table for customer info and table for items. I'm just wanting to be able fill out customer information and then select items from a list for that individual customer form. Then have all that information stored together so that I can go back and choose or delete an item a customer doesn't want

 

[BlueIshDan]

Ok so create another table that stores the instances of selected items.

 

[GinaWhipp]

Hmm, are we missing a table? Is there a table for *Customer Items*? Because I'm going to assume a Customer can have more than one item. Then you can easily link Customers to Items. That said, why not show the items in a subreport?

Side note, you don't edit the information in the Report, you do so in the Form and rerun the Report.

 

[BlueIshDan]

I need to learn to describe what I know like that haha. Thanks Gina!

 

[cmfog]

Would I create a relationship between all 3? And if so I'm not sure how to relate them

 

[GinaWhipp]

@cmfrog

tblCustomers
cCustomerID (PK)
etc...

tblItems
iItemID (PK)
etc...

tblCustomerItems
ciID (PK)
ciCustomerID (FK -relate to tblCustomers)
ciItemID (FK - relate tp tblItems)
etc...

Seems like you're new to this. Here's some reading that should help...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

UtterAccess Newcomer's Reading List
http://www.utteraccess.com/forum/Newcomer-s-Reading-List-t1998783.html

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html
http://www.databaseanswers.org/data_models/

Naming Conventions…
http://www.access-diva.com/d1.html

Other helpful tips…

Setting up a Model Database
http://www.access-diva.com/d11.html

My Database Standards...
http://regina-whipp.com/blog/?p=102

 

[GinaWhipp]

@BlueIshDan

Just think like a teacher... a really great one and you will! My inspriation is my sixth grade teacher, Ms. Joan Carvo! If she were alive today I would niminate here for *Teacher of the Universe*!