Re: Best Practice for tables?

Tech-Archive recommends: Fix windows errors by optimizing your registry

It sounds right if it's that simple. Instead of using the actual text from
the 3 tables, use the ID or Primary Key value.The tblRoutingSystem should
contain:

CountryID
DispatchMethodID
SupplierID

Now if the Supplier decides to sell the company or change its name, you
simply change it once in the Supplier table, and it propogates throughout
the database from the queries used to display the SupplierName.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Kamitsukenu" <Kamitsukenu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:72266BF7-C758-4089-A0BD-71AE9551859A@xxxxxxxxxxxxxxxx
Hi there,

The company I work for mail items dependent on destination, weight and
speed
of delivery.

I'm trying to make a system in Access, and during setting up all the
tables,
I'm getting myself more and more confused.

I have the following tables;

(tblCountry) - holds the Country names
(tblDispatchMethod) - the service the item is sent by
(tblSupplier) - who the item is mailed by

Now, as dispatch of items are dependent on the weight, I have another
table
which combines all the above information.

TblRoutingSystem contains
'CountryName' which refers to 'tblCountry'
'DispatchMethod' which refers to 'tblDispatchMethod'
'NameofSupplier' which refers to 'tblSupplier'
'WeightBandStart' and 'WeightBandEnd' which refer to (surprise, surprise)
the start and end of the weight bands for deciding the correct supplier
for
mailing.

Does this sound about right, or should I be split them out further or
should
I be merging more stuff together.

in fact, can someone go through the pros and cons of creating more tables
to
suit the data?

Thanks

K




.

Relevant Pages

  • RE: what to use
    ... E contains the name of supplier, this supplier have sent xx shipments to us ... The first supplier in E2 is Mini press, and in K the weight is 80 then I ... where the result from the transporters report will get ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Relational query with path expressions
    ... pounds or are supplied by supplier S2 or both. ... I think equivalence of these depends on a FK constraint from SP.P# to ... asterisk expands into all the attribute names from the input relation. ... P(*(-COLOR, WEIGHT as W), SP.S.SNAME) ...
    (comp.databases.theory)
  • Re: Update Query based on a value between two fields
    ... UPDATE TableA INNER JOIN TableB ... with TableA supplier and weight and table b supplier. ...
    (microsoft.public.access.queries)
  • weight calculation
    ... I'm stuck with a problem, and I think its easy solved for a clever mind:) ... Is there anyway I can summarize the weight on each supplier, ...
    (alt.php)
  • Re: Ping Jujitsu Lizard....
    ... you're dealing with someone who thinks "sprung ... weight" refers to how much he weighs immediately after posting ...
    (rec.motorcycles)