First of all, Thank you to all who are willing to help and have helped so far! I am essentialy making a billing database for a department that charges other...

Hi, DESCRIPTION ------------------------ I am trying to build a simple CRM solution on Ms Access. I have a table where I have basic sales leads information...

I am working on a complex database to store Business information as well as specific into about that Business... here is the tricky part... The individual...

I have a table whos records are organized by a composite key of 3 ID's from 3 different tables. What is the best way to get the ID values from these 3 other...

I am in the process of developing an access database that would track account compliance. I receive an excel file that has Sales figures and market data on a...

Hi, I've had a look around in some of the questions here and especially the ones from Tina, Allan and Rebecca - but I'm a bit stuck; I need a little sparring...

i have orders which have different requirements, for example order 1 = requirement1 order 2 = requirement1 requirement2 requirement3 order 3 =...

I am trying to figure out the best way to set up a relationship. I have a table that has job information (ID, address, dates, etc.). I also have a table...

I have an application that I developed in Access. It looks at the system date and time for certain events. On some computers it works and on others it...

Hi! I am trying to create a unique composite index. The index would use two integer fields and two time fields. Access keeps complaining about creating the...

I have never dealt w/ a composite key before. I have a table with primary keys of itemsku and date. Does this Composite Key guarantee that there will be no...

I have a cases table I want related to a people table. The cases table has 2 types people A and people B. I want these two fields to be auto enter number...

I have a composite key made up of two fields. How would I create a relationship between this table and another (foreign) table? -- Yo Yo Ma.

Hello, Can you give me a plain description of the difference between Composite Keys and Primary and Secondary keys? I thank you for taking time to help...

Hi. I'm trying to add a section to my database and I'd appreciate help on the best design method. We hold an auction every year. We have a sit-down dinner in...

Here's my table: CREATE TABLE Test1 ( employee_ID INTEGER NOT NULL, start_date DATETIME NOT NULL, end_date DATETIME, PRIMARY KEY (start_date,...

I have a table TBL_Tech that has its PK as the TechID. This is the FK for two other tables. I just found out that after a tech is terminated, the supervisor...

I'm trying to figure out the best design for a new database for a composite primary key (CPK) where one of the fields may be a NULL - a violation of a primary...

I am beginner with db's so this maybe very simple question or misunderstood by me but let's try. I am trying create db to record my customer jobs and car...

I would like to create a composite primary key using two fields: a random integer ID, and a "line number" index. I want the index to be incremental, start...