CLICK HERE AND JOIN CHRISTIAN GUITAR TODAY!
Welcome to the Christian Guitar Forum.
Welcome to Christian Guitar, the world's largest Christian guitar resource and forum community where over 150,000 Christian music fans from around the world come to discuss all Christian music, living the Christian life, current events, etc. in over 3,000,000 posted discussions!

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and photo galleries. By joining our FREE community you will have access to post topics, communicate privately with other members (PM), blog about your Christian journey, suggest and share guitar tabs, see LESS forum advertisements, upload photos in your own photo album and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

Old 06-26-2003, 06:03 AM   #1
I'm a girl of God ....
 
soaring_eagle's Avatar
 
Joined: Dec 2001
Location: Brinklow, near Coventry UK
Posts: 740
Send a message via AIM to soaring_eagle Send a message via MSN to soaring_eagle Send a message via Yahoo to soaring_eagle
Microsoft Access problem

Right, i'm doing ict at school and we're making a database for a shop. I've got this form sorted.

What i want to be able to do is to delete this order for the item (but beware i want to keep the stock levels so that they are correct, at the moment they change the levels of stock when you order an item) so that if the customer changes their mind then the stock control thingy will still be accurate and uptodate.

Thanx

__________________
my website... HappyZenith

i'm currently feeling: <a href="http://www.imood.com/users/soaring_eagle"><img src="http://moods.imood.com/display/uname=soaring_eagle/imood.gif" alt="The current mood of soaring_eagle at www.imood.com" border="0"></a>

Last edited by soaring_eagle; 06-26-2003 at 06:09 AM.
soaring_eagle is offline   Reply With Quote
Sponsored Links
Old 06-26-2003, 12:52 PM   #2
Registered User
 
Joined: Jun 2001
Posts: 2,805
Never used Access, so, sorry, but I can't help...
Young Twig is offline   Reply With Quote
Old 06-26-2003, 01:31 PM   #3
JT
 
Joined: Jan 2002
Posts: 3,339
I've used Access plenty, but I'm really not sure what you're asking. Is there something not working? Do you need help getting started?
Jay Tea is offline   Reply With Quote
Old 06-26-2003, 02:26 PM   #4
Real candidate of change
 
Joined: Sep 2001
Location: Tampa, Fl
Posts: 15,685
Send a message via AIM to JerryLove
If I understand your description...

I would not recommend keeping a "number in stock" table and deleting from it when an order becomes pending... You would do better to create a query-table on a regular interval which had the number available based on "inbound", "arrived, "pending", and "completed" tables. Use a query to the "pending" table to subtract from the "inventory" table.

Alternaely, you can actually move the items from one table to another. When an order is placed, don't just remove it from inventory; move it to a "pending order" table. Then don't delete the order, cancel it, and move it from the "pening order" table back to inventory.

There are several ways to accomplish all this... from a purely business standpoint, the preference is a master record and query tables for the status's... from a project standpoint, you can probibly just create the 4 tables yourself.
JerryLove is offline   Reply With Quote
Old 06-27-2003, 03:24 AM   #5
I'm a girl of God ....
 
soaring_eagle's Avatar
 
Joined: Dec 2001
Location: Brinklow, near Coventry UK
Posts: 740
Send a message via AIM to soaring_eagle Send a message via MSN to soaring_eagle Send a message via Yahoo to soaring_eagle
okay so i didn't attach what i wanted to start with, which doesn't make it that clear, sorry. This is what i have at the moment, does it help?
__________________
my website... HappyZenith

i'm currently feeling: <a href="http://www.imood.com/users/soaring_eagle"><img src="http://moods.imood.com/display/uname=soaring_eagle/imood.gif" alt="The current mood of soaring_eagle at www.imood.com" border="0"></a>
soaring_eagle is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -6. The time now is 10:28 PM.