I was thinking about uploading my little DB for critique and suggestions. Is this a proper use of forum? If it is I will upload. Really all I want to do is keep a container count, i.e. Boxs, cartons, vats,. Weight in lbs, shipper and reciever, a notes field. and lastly some useful reporting to produce a shipping manifest. Anyone game?
Freight master
- Thread starter Royboy
- Start date
John Big Booty
AWF VIP
- Local time
- Today, 23:30
- Joined
- Aug 29, 2005
- Messages
- 8,262
Feel free to upload your DB for a critique.
Remember you'll get a better response if you are able to post it as '03 version
Remember you'll get a better response if you are able to post it as '03 version
Ok then, thanks for the go ahead. First off let me say that I'm a truck driver by trade nowadays. I built this DB in order to record freight that I pick up in Boston. Look at it and let me know what you guys think. Its not in 03 but I'm working on finding where I placed the drive I have it saved. Any way I'm convalescing for a week or two and figured I would put this spare time to good use, scrapping some rust off the old noggin. Thanks again.:banghead:
Having a booger of a time trying to get this file attatched. Hope I'm not being to much of a pest. I'mgoing to try attatching it again, I removed all the records 15000 or so. I did leave 160 or so, just to give it a feel of what I use it for.
Last edited:
John Big Booty
AWF VIP
- Local time
- Today, 23:30
- Joined
- Aug 29, 2005
- Messages
- 8,262
Try doing a compact and repair on your DB then put it in a zip file then try and upload it.
- Local time
- Today, 09:30
- Joined
- Jan 23, 2006
- Messages
- 15,571
I looked at your database briefly. I've read here what you say it's purpose is, but I'm not sure how to use it and/or get info from it.
A few comments:
There are no relationships between your tables. Proper relationships and table structure could make life a lot easier for you.
I'm sure you know each and every piece of what you have.
My recommendation would be to research Normalization and autonumbers. Confirm that your deign really represents WHAT you are trying to do. Set up appropriate relationships and referential integrity to add some discipline to your processes.
Normalization will identify Primary keys for your tables, and identify Foreign keys for related tables.
Good luck with your convalescing and data base project.
A few comments:
There are no relationships between your tables. Proper relationships and table structure could make life a lot easier for you.
I'm sure you know each and every piece of what you have.
My recommendation would be to research Normalization and autonumbers. Confirm that your deign really represents WHAT you are trying to do. Set up appropriate relationships and referential integrity to add some discipline to your processes.
Normalization will identify Primary keys for your tables, and identify Foreign keys for related tables.
Good luck with your convalescing and data base project.
Similar threads
Solved
Query v Function
