Building new Data Base

[dave1234]

Is there anyone that could build me a simple data base, basically I need it to be able to enter stock names so when new stock arrives I can pick it from a drop down menu and add a quanitity and clients details so I can invoice stock out to clients.

Then the big one.....be able to do a stock take when ever I want, also would like to be able to tell what clients have bought what stock between to dates that you would be prompted to put in.
Can anyone help I'm so lost at trying to do it myself any help would muchly appreciated.
my email address is

gorey_dave@hotmail.com

 

[Rich]

Use one of the Database Wizards to start with, then you'll be able to cutomise it to suit.

 

[SAK]

First off, sounds like you should start with two tables. One listing all your stocks by StockId and StockName. Then a table for the records you want to, maybe tblStockPurchases.

For the drop down choice of stocks for your tblStockPurchases table, set a field to be called StockID, then use that lookup wizard option for the data type in the design mode for the table. That is pretty slick and will give you that option to drop down and select.

There's another way to do that on the form, using the SQL, but for starters try that.

 

[WayneRyan]

Dave,

You're gonna confuse everybody. This is posted in Forms,
Queries, Tables and here.

Wayne