Order Processing App

[AD108]

Forgive the double posting, but I think the first group I posted this in was
too obscure, with only few postings a day.

Hello,

I am just learning to develop apps with Access. I have a bit of experience
developing Excel apps, using VBA.

I need to design a Produce purchasing and distribution application. It will
need to handle incoming and outgoing product, invoice tracking, pricing,
etc.

I'm sure there's a million ways to do it, but my main question at this point
is how to set up the app to handle incoming orders, and retain those orders
until they are filled. My initial thought is to set up a table called
tblOpenOrders, that would relate to the Location, Incoming Orders and Item
Tables. I was going to make its primary key the Item Number field, from the
Item Table.

I was thinking to make an Open Order field in tblOpenOrders. The value
would increase with any incoming order recieved, and decrease with any order
filled, using some type of code or calculated field. Does this sound like a
good approach?

Thanks
Ariel

 

[Larry Linson]

You received at least one answer in the other group. But, by being
impatient and multi-posting, you might have irritated some people who might
potentially have answered future questions for you. See the FAQ at
http://www.mvps.org/access/netiquette.htm for good suggestions on effective
use of newsgroups.

I suggest you visit http://support.microsoft.com and search in the Access
Knowledge Base for "Orders and Solutions". That will get you a link to a
sample Orders database -- I've made no evaluation or judgement as to whether
it is useful, or well-designed, but it is an example.

Larry Linson
Microsoft Access MVP

 

[AD108]

Thanks very much for the advice Larry,

Ariel

You received at least one answer in the other group. But, by being
impatient and multi-posting, you might have irritated some people who
might potentially have answered future questions for you. See the FAQ at
http://www.mvps.org/access/netiquette.htm for good suggestions on
effective use of newsgroups.

I suggest you visit http://support.microsoft.com and search in the Access
Knowledge Base for "Orders and Solutions". That will get you a link to a
sample Orders database -- I've made no evaluation or judgement as to
whether it is useful, or well-designed, but it is an example.

Larry Linson
Microsoft Access MVP