Query or Tables

[finsmith]

We are trying to develop a database that contains a entire list of all items.. LOM



A person will type into DB_1. This will contain items such as item no, qty, drawing no, description of the item. That will also go into the LOM, all items included.

DB_2 will be Location, model no, materials needed. And again will populate into the LOM

Should i be running a query, forms? relationships? new at this any help is appreciated.

[alansidman]

You should be entering your data into your tables employing forms. You should then if you wish to extract information employ queries and/or forms.

What is an LOM? Establish relationships between the tables.

Here is a good reference to read before starting

http://www.deeptraining.com/litwin/d...aseDesign.aspx