Liveson, Thank you for all the help. I have been working on this and seem to be making some progress. I have set up two tables (customers and inventory). What would be the difference between the three tables: orders, invoices, and receipts? Right now, my "invoices" look exactly like my "orders" and I don't currently have anything called "receipts" so I'm a bit confused. ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~ Rhonda
Sugar Bearz ~ Fine Quality Children's Gifts & Clothing www.sugarbearz.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Liveson Sent: Monday, April 10, 2006 11:43 AM To: [email protected] Subject: Re: [ms_access] questions Rhonda I assume you are a bit familiar with relational database management system which MS Access is all about. From your description I feel you should have the following tables with their primary and foreign keys: Customers with primary key CustomerID Orders with primary key OrderID and foreign keys, CustomerID and ItemNo Invoices with primary key InvoiceNo and foreign keys OrderID Items with primary key ItemNo Receipts with primary key ReceiptNo and foreign keys InvoiceNo and optionally CustomerID (it may not be necessary to have CustomerID field in this table because this table is related to Customers table through Invoices and Orders tables). These 5 basic tables can get you started. From your spreadsheet you should know which fields to add to each table. Create relationships of these tables based on primary and foreign keys. It is a good practice to enforce referential integrity at this point. Thereafter you can build your forms, queries, reports, etc but first the table structure should be solid. Once you have these properly set up let the group members know so that they can guide along the way. HTH Liveson ----- Original Message ----- From: "Rhonda Jenkins" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, 10 April, 2006 16:18 Subject: RE: [ms_access] questions I run a small internet retail store. Thus far I have been keeping my records (orders, inventory, invoices) in separate Excel spreadsheets. I want to start keeping my records in Access so that everything can be connected and I won't have to open several spreadsheets and enter the same information repeatedly. I just don't know where to start. I have found templates for customer order databases, inventory databases, etc. Wouldn't all of this need to be in one database to do what I want to do? In a nutshell, I want to be able to enter a customers name and address, the items they ordered, method of payment, etc. one time and have it spit out an invoice, and update my inventory records, update my expense sheet for shipping costs, etc. Is this possible? Where do I start? ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~ Rhonda Sugar Bearz ~ Fine Quality Children's Gifts & Clothing www.sugarbearz.com [Non-text portions of this message have been removed] Yahoo! Groups Links _____ YAHOO! GROUPS LINKS * Visit your group "ms_access <http://groups.yahoo.com/group/ms_access> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . _____ [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
