Help

[Hugo]

Hi, I am trying to run a data base a bit complicated for my head.... I have table 1 with zip codes and zones, table 2 with units and lbs and table 3 with zones and shipping..... what I really want to do is : 1)if you enter enter a zip code 100 (I need to add that this need to include anything from 100 to 199 for eg., so my next zip code is 200, etc.) it will tell me which zone is related to...... 2) when I enter a number of units (again saying 1, 5... when 1 would be equal to anything equal to 1 and less than 5) my answer would be the weight or lbs.... 3)weight should be related to a zone and to shipping charges............ then I would need to create a form or report to enter a zip code, make the program to look for my zone, enter # of units get the weight, make the program look for shipping charges base on weght and zone...... can anybody help me?

 

[Cosmos75]

A litte bit consufing for me.

For 1) I think you need to have two tables, one for Zone and one for Zip Codes with a one-to-many relationship (One Zone has Many Zip Codes)

tblZone & tblZipCodes

Then have a query that pull that data back. (qryZoneZip)

Then you need a tbl to store these fields
tblOrder
-Weight
-ShippingZipCode (Zip Code of orderer)

I assume the shipping charges depends on Zone and weight.

So now you need a table to store the Shipping rates.
tblWeightClass
Field: Weight
I'd just put 5 and use 5 to mean Less than 5.

Then a junction table to link tblZone and tblWeightClase called tblRate.

Then have a query to join all that up to use to find the correct rate. (qryRate

Then have a query (qryOrder) select those two fields, have it find the correct zone from qryZoneZip. Use the zone and Weight (tblOrder) to find the correct rate from qryRate.

That should get you started. I hope that will work, I've been working on my own database and my brian is a bit fried. I apologize for any errors ahead of time and will try to help you more when I can think straight.

 

[Hugo]

thanks a lot, and yes probably I might need more help, I am not an expert on Access but at this moment I am totally lost and got not idea at all................