Glenn...can I email you the file that i am having problems with and if you could take a look at it. I apprecitate it.
Thanks --- In [email protected], "Jones, Glenn P MSG (Ret) FL-ARNG" <[EMAIL PROTECTED]> wrote: > > You can see this model in the Northwinds database which comes with Access. > Basically you will want three tables. One table will be for your customer > information where CustomerID is your primary key (PK). > > The second table will be like an inventory table listing your products, > price, item number (PK), and on hand quantity. > > The third table is what is called a join table. This table will be your > Orders table and will join the information from your Customer table > (CustomerID) and from your Products table (ItemNumber). You will also want > other fields in your join table such as quantity, order date, ship date, > various costs such as shipping and handling, total cost. The reason you > want a separate order table is because you may have a customer that orders > more than one time. When the order is placed you can subtract the quantity > ordered from the quantity on hand. You could set an OrderWhenQuanity value > for each item in your inventory table and then when the quantity on hand is > equal to or less than that OrderWhenQuanity value you will know to order > more of that product. > > I hope this helps. > > Glenn P. Jones > > > > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of peaches1979_2001 > Sent: Thursday, 22 December, 2005 01:00 > To: [email protected] > Subject: [AccessDevelopers] Need Help with my Access File > > > Can any one help me with my access file? I could not able to upload to > the group in the files folder. > > I have these two tables: > > Customer: ID, Name, Address, City, State, Zip, Email > Sold: Auto Number, Item Number, Discription, Qty, Price > > How do I link them to the Customer ID just using that? I want each > record different for the customer so that I could have a copy of it. > > I setup my query using the auto number, but it tells me it is invaild > expression. IF anyone could help me with it, I appreciate it. > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
