RE: Creating a quote form

From: Sprinks (Sprinks_at_discussions.microsoft.com)
Date: 01/06/05 

Date: Thu, 6 Jan 2005 11:13:04 -0800

Hi, Eric.

You will need four tables at a minimum:

Customers
===========
CustomerID AutoNumber (Primary Key [PK])
CustomerName Text
Address
Phone
etc.

Products
===========
ProductID AutoNumber (PK)
Product Text
etc.

Quotes
===========
QuoteNumber AutoNumber or Number (PK)
CustomerNumber Number (Foreign Key to Customers [FK])
QuoteDate Date/Time
Any other fields that are strictly related to the Quote itself, not the
specif items quoted

QuoteItems
===========
QuoteItemID AutoNumber (PK)
QuoteNumber Number (FK to Quotes)
ProductID Number (FK to Products)
Qty Number
UnitPrice Currency
Discount Number
etc.

There is a one-to-many relationship between Quotes and QuoteItems. Create a
main form based on Quotes, and a continuous subform based on QuoteItems.
Drag the subform to the main form in form design view.

To print the report, which will no doubt have the Customer Name, the Product
name, that is, fields from many tables, create a multi-table query, linking
each table's primary key to the corresponding foreign key in its related
table, and base your report on it. Group the report on QuoteNumber.

Hope that helps.
Sprinks

"Eric" wrote:

> I'm trying to create a quote form for my company. What is the easiest way to
> get information from a combo box onto a report (multiple selections from the
> combo box)? I want to make a form so that you can select a tree(the plant),
> enter a quantity, and have it saved somewhere so it can be later sent to a
> report. On each quote, there will be multiple tree selections. Where do I
> store the selected information?

Relevant Pages

  • Re: Many to Many Relationships
    ... up a combined primary key with the primary keys from the ... I need to be able to track all Quotes and there ... I have Customers that may have Quotes and Jobs and I may ...
    (microsoft.public.access.tablesdbdesign)
  • More assistance with Many to Many Relationships
    ... up a combined primary key with the primary keys from the ... I need to be able to track all Quotes and there ... I have Customers that may have Quotes and Jobs and I may ...
    (microsoft.public.access.tablesdbdesign)
  • sort in ascending order
    ... I created a report from a query, which displayes customer names and products ... This report sorts customers by ID (primary key) in ascending ... I want to change that to customers' last and first names in ascending ...
    (microsoft.public.access.reports)
  • Re: FW: Double Quoting in Table names causing dynamic method access failures
    ... quote)access' (without the single quotes of course). ... there are aready DBI methods to get the primary key ... report, or raise the issue on one or both yourself. ...
    (perl.dbi.users)
  • RE: How we get record from two database and insert into other database
    ... Create a primary key in the Customers table. ... Create a relationship between the Orders table and the OrderDetails ... The data type is string for this element, ...
    (microsoft.public.vb.database)