Database design

I want to make an equipment tracking program. I will need a DB with "Customer Names" and "Locations" as two of ten or more fields. Half of the fields will rely on the "Locations" field. Example, I want the customer name to be at the top of the form, with a listview containing the locations, product, size, zone, etc. below it. How do I do this. Can I load the ListView with "Locations" etc. by selecting to load "Location" Where Customer = "ABC Co." or will that just load one "Customer" record? I hope someone can understand this quetion. Do I need two DB's, and if so, how do I open two different ones into one form? I don't need code as much as a general how-to. Thanks.

Hi, as i can understand ur problem what u just need is two well normalized tables in ur database. If u can understand normalisation half ur problem is solved. A general practice is to have the tables normalised upto the third level. Remember there are Five levels of Normalisation. I believe that with normalisation even complex problems are easily solved. Here is a short note on each of them. Please i am not sure of the order but at the end of the third level all these are achieved.

i) Elimination of Null Values - Level I
ii)Elimination of Repeating Groups - Level II
iii)Elimination of Non-Key dependencies - Level III

It is something like this, if a record in a table can be identified by a unique key then that key is the Primary Key for that (Employeeid for a Employee table will be the Primary Key) like wise all related information can be grouped in a table and u can always find a unique combination of keys to identify the entire record. (Unique combination because - they are generally called the Composite Primary Key). Still confused, no problem, if u can mail me ur data may be i can help u with the solution. Please mail to [email protected]. all the best...vijay

Can I create a DB named Customers.mdb, then put a "Customer table with tables that contain information that is the same no matter what the location, such as office phone and so on. Then have a "Location" table that would have location specific information such as equipment number, location name and so on. I want the location information in a ListView and customer name and what ever else in that table can be in text boxes. Then write a routine to load textboxes( Select CustName, OfficePhone From Customer) and a routine to load the listview(Select EquipmentNumber, LocationName, customer From Location Where customer = txtCustName.Text) Not this actual code but just to get the idea across. If I load the textboxes first, can I use the current customer displayed and use txtCustName to get all locations that have a matching customer name field. I doubt anyone can understand this, I've confused myself now. Would this be a repeating group?

Should I use a DataGrid instead of a ListView? Which would be easier to load?

Hi, i can help you only if i can have the complete scenario of your problem.

I am still not clear in my mind as for ur requirement. what exactly are u trying to do.

A story like this would do to me...

I have a location where there are some customers and when i select a location i want to see the list of customers and when i select a customer i want to see information specific to that customer etc.,. if u can mail me such a story i can assume some information for myself and mail you my assumptions and results basing on it.

please feel free to do it to [email protected].

with regards,

vijay.