Search results for query: *

Hi All, I'm pretty much learning as I go along so bear with me. I am trying to develop a database in SQL Server 2005 for tracking manufactured items on projects. We manufacture conveyor systems and I am trying to track certain manufactured item information for sales and support purposes, such as...

Hi All, I am in the process of developing a database on SQL Server 2005 and I am wondering if there are any guidelines I will need to follow in order to ensure that the resulting database will attach and run on SQL Server 2000. I work for a small engineering company and I do some small software...

Hi fneily, Thanks for the excellent link.... some great information. I'm not too sure how the relationships will work if I make the suggested changes, I might be missing something. Maybe you could elaborate a little on your explanation. Anyhow, my understanding is to create a relationship...

Thanks guys for the quick replies. What I basically have is the following tblCustomers (PK: fldCustomerID) tblLocations (PK: fldLocationID) tblProjects (PK: fldProjectID, FK: fldCustomerID, ) The data in tblLocations is the LocationID, the CustomerID, LocationName. Since each customer can...

I'm a relatively new to creating databases in Access and recently I have created a database for tracking items manufactured on projects. So far so good, until today when one of my colleagues asked if I could include the following: He wants to be able to filter all projects, per customer and...