Can any one tell me how to create a unique constraint on
multiple fields WITHOUT setting them as primary key.
Regards
Sajid

I am implementing (what a dreamer) a multi-table db.  One of the tables had 18 fields in it and a little logic suggested I split it into 2 tables.  In attempting to delete fields from the table, I kept getting the message above.(256 fields is max)  It would not save any changes, ...

I need to track calendars for 25+ people.  In addition I
need to track information on what they are doing and the
accounts that they are visiting.  I then have to share
information through reports and calendars.  I am a

When linking 2 tables together in a one to many relationship I get the following error message when I try to enforce referential integrity.
'No unique index found for the referenced field of the primary table'
The primary table has 5 fields as it's primary key.
Any ideas anyone

I would like to create a new database on my hard disk
from within a current one. I would like to be able to
create it in a subdirectory of my choice ex:
C:\MyDocuments.

I have a table which I need to create for normalization purposes. It will
have the PK of two different tables, and that will be all.  I cannot figure
out how to make them both the PK of this new table. I think you cal it a
composite key when you have two fields as the PK. So I ...

I used the security wizard to create a group of users. I set some to read only and another to Full permissions, but everyone in the group can open and make changes to forms and queries. I also gave each person a password, however, I am the only one that gets a pop up box to enter ...

Please help.
We created a database and used autonumber to keep track of
the number of records (i.e. order numbers) and set
autonumber as follows:

I want to create a very basic database for employee phone
numbers.  I have 2 tables:
Department & Employees
Department table consists of 2 fields:

I am a novice and need some help!
I have created a database that stores all our companies
proposals, purchase orders in/out, invoices, delivery
dockets etc.

How do i edit/remove records within my newly created mdb
access database file.  When i double click the file, an
empty shell of a program comes up with no content.  Using
shift while opening it does not work either.

Looking for a programmer in my area to write code for
Access database.  Need to create a coulple reports to then
be able to export data for use in Excel spreadsheets.   I
live in Camarillo, California.   Work needs to be done

I am trying to design a (relatively) simple billing module
for our database. Its core is a table in which each record
represents one invoice. However, each invoice may have
multiple line items, depending on the  type of service

I am beating my self up here
I have a combo box with all the part numbers in it. I have a query that should select all request records if the combo is blank (IE nothign has been selected yet) or should limit the query to a specific part number if one is selcted. I have been tryin ...

I have a table with the field (ProjectID) is set to
primary key.
My manager want to enter a this field with start number
00001 to 99999. But when I enter for 00001 then all of the