[mso] Re: Access question :VSMail mx3
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Wed, 9 Apr 2003 08:35:16 -0700
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]
Sent: Wednesday, April 09, 2003 6:44 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Access question :VSMail mx3
Lets see where to start.
1. Access is divided into 2 parts.
a)One part has the tables (44) One is the master with all items and pricing
info one is descriptions and other items not use often. Leaves 42 other
tables with each list of Items that is sold to each company. [We send out
pricing updates to each company of items only they buy from us]. I have most
tables set with relationship to Cascade Update Related to code (primary key)
. Since Access limits how many relationship you can have I had to do a work
around ( Master Table relation to Description Table then a relation to a few
tables so they get the new code.)
b)2nd part has the forms and queries and reports.
2. At this time 3 different people use us it. I have to now let someone else
use it. She works in a different town. We are networked. My Questions is:
What's the best course to do the new tables (about 15) I need to build for
her companies she deal with. She will use the Master table and the
description table, I need to add relationship so if a code is change it will
change on your other tables. Should I have a file for just the Master Table
and Description Table? Then do a 2nd file for each town set with there
tables and have the master and description link with the relations set
there?
Note: I build the 2nd part of the database as a .mde for them to use.
Sometimes it gets updated once a week. Each time they will have to relink
all the tables.
Do you think it would be best to make the tables set on a SQL server? Since
I have so many tables that needs to have a relationship say 75 tables? If so
what's the next step?
Karen
*************************************************************
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
*************************************************************
*************************************************************
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:
