help setup db to track unique to customer orders history

[Getting_By]

We are a mfg company. We want to create a db that would make it easier to set
up an order history for each customer. Each of these customers has a variety
of different items that are unique to them. We wish to setup new items within
the customer form so we can enter and track the items and their history on
the fly

Help

 

[Steve]

If you want help creating this database, I can help you. I provide help with
Access, Excel and Word applications for a nominal fee. Contact me if you
would like my help.

Steve
(e-mail address removed)

Here are a couple of customer comments after I helped them .........

Thanks for your work; it is just what I was looking for! You're good.
This is only the second time I've contracted out Access development, you
were the first, you did a fine job the first time but this time I
thought I'd see what the open monetary marketplace could provide. Let's
just say you are the only one who has been able to get me the result I
was looking for and I didn't have to spend any time explaining the
details to you.

Scott Rich


I imported all of your additions this afternoon. It works great. Thank you
so much.
Please send me an invoice and I will send check.
Thanks again..I enjoyed spending the time on the phone. Hope I can call you
again the next time I need help

Rhonda Marko

 

[John... Visio MVP]

If you want help creating this database, I can help you. I provide help
with Access, Excel and Word applications for a nominal fee. Contact me if
you would like my help.

Steve
(e-mail address removed)

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

A few gems gleaned from the Word New User newsgroup over the Christmas
holidays to show Stevie's "expertise" in Word.


Dec 17, 2008 7:47 pm

Word 2007 ..........
In older versions of Word you could highlght some text then go to Format -
Change Case and change the case of the hoghloghted text. Is this still
available in Word 2007? Where?
Thanks! Steve


Dec 22, 2008 8:22 pm

I am designing a series of paystubs for a client. I start in landscape and
draw a table then add columns and rows to setup labels and their
corresponding value. This all works fine. After a landscape version is
completed, I next need to design a portrait version. Rather than strating
from scratch, I'd like to be able to cut and paste from the landscape
version and design the portrait version.
Steve


Dec 24, 2008, 1:12 PM

How do you protect the document for filling in forms?
Steve


One of my favourites:
Dec 30, 2008 8:07 PM - a reply to stevie
(The original poster asked how to sort a list and stevie offered to create
the OP an Access database)

Yes, you are right but a database is the correct tool to use not a
spreadsheet.

Not at all. If it's just a simple list then a spreadsheet is perfectly
adequate...




John... Visio MVP

 

[PieterLinden via AccessMonster.com]

We are a mfg company. We want to create a db that would make it easier to set
up an order history for each customer. Each of these customers has a variety
of different items that are unique to them. We wish to setup new items within
the customer form so we can enter and track the items and their history on
the fly

Help

How is this different from a standard
Customers -- (1,M)--- Orders---(1,M)---Order Details ---(M,1)---Products

database? If you don't purge the orders or order details, then you have
their order history already. Proper indexing should make the database work
fine. If you wanted to populate a list of "Frequently Ordered Items", you
could write a query to do that...

 

[Gina Whipp]

I'm not sure I understand....

You offer to help people who come to these FREE newsgroups for a fee and
then...

....post questions in this FREE newsgroups on how to create their database
for them?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Getting_By,

Take a look at the Northwind database... This should be a great start for
what you want.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[CraigH]

Hi Getting_By,

Adding to Pieters - and yours

Inline:


New items would be easier to set up on it own form - assigning it then
to a specific customer then could be done either on the Product form or
Customer form with a subform.

so we can enter and track the items and their history on

How is this different from a standard
Customers -- (1,M)--- Orders---(1,M)---Order Details ---(M,1)---Products

Assuming this standard start for the layout you will need to add the table
that states what products are related to a specific customer.

tblCustomerProducts
CustomerID
ProductID
CustomerNumber ' I put this in to show how I used this format - Customers
needed different numbers (used on the Invoices) for the same products that we
produced.

You can either have a 1 customer to 1 product ID or as we needed many
customer could have the same product. Any product not in the list is assumed
to be available to all.

database? If you don't purge the orders or order details, then you have
their order history already.

Yes, but you don't have the products that they didn't order that are
specific to them.

and you can't limit the order detail subform to those products that they are
alowed to order that are specific to them.