[mso] Access question :VSMail mx3
- From: Karen Willingham <kwillingham@xxxxxxxxxxxxxxxxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Wed, 9 Apr 2003 10:43:38 -0500
James I have a different table set up for each company because of 2 reasons.
1st. Some one checks each month what is sold to each company, and makes sure
what we have set them and what they have listed on there end is right.
(sometime we send price change and they do not get it. If they do not have
the right price in there system the item gets set back to us.)
2nd. there are columns on each table (code is the primary key) that tell us
if that company buy by the bottle or case (bottle as a uncharged) and their
special item number that has to be printed out on there special report. Each
company sent us how they want their report to look like.
Karen,
Anthony seems to have answered most of your question. I am curious about
your set up. The way I read it you have a separate table for each company
you sell to? This is probably not the most effecient way to have this set
up. If this is the case, we could probably help you cut down on the number
of tables you have and allow you to add new companies much easier. If you
would like to explore this idea further please let us know and we can take a
look at it here.
James La Borde
-----Original Message-----
From: Karen Willingham [ mailto:kwillingham@xxxxxxxxxxxxxxxxxxxxxxxxx
<mailto:kwillingham@xxxxxxxxxxxxxxxxxxxxxxxxx> ]
Sent: Wednesday, April 09, 2003 6:44 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Access question :VSMail mx3
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
