Do the field properties have to be the same for the primary key and the
foreign key? If I have long Interger on one does the other have to be the
same?

I am sort of new to this, thus bear with me if my explanation to my problems
sounds confusing. Anyway, here it is:
1) I've created 2 tables ( Employees & Leaveinfo)
- In the employee table, I've got the details of the employees name,

I' m kanda new to this forum. I have searched my question in the forum, but
it returned a million posts. Anyway, in my database, I have three tables, one
table is the partlist, one is customer, and orders. In the order form,
customer places an order, part number will be selected ...

I want to enter the following into a field as a default descriptor ,"SE", and
"," and ," as examples. These are for replications that have to take place
from the Access Database that contains the information to a server that can
only interpret comma deliminated values from a text ...

I have an invoicing database that was created but with errors, and not
completed.
I am taking bids from people to finish this database for me, and will pay
for someone to download the base database file from my web site and then send

Can I enter the results from a calculation into a field in a table?  For
example, if my table has three fields: Price, Cost, and Profit, how can I get
the profit to be calculated and inserted automatically into the Profit Field?
I can do it easily in a query and/or form, but I ...

I am trying to generate sql scripts from Access database that can be used to
create databases in different database systems. I have tried a few third
party tools such as Interbase Data Pumper and SQL To Interbase Wizard;
however, they don't do the job well.

At the data Validation dialogue box when I am entering the  “=ID” that what I
Define my data name I gate this error “You may not use references to other
worksheets or workbooks for data validation criteria” this is only happening
on my 2003 excel. I have open two workbooks in the ...

Iam About to store around 4000 samples in a storage area in a small shelf,
and I will assign a name and number for each shelf to keep all samples in ,
then I need to make a program using access to enable employee to input the
sample number and the program should give him the ...

 I have an inventory database with the table design as follows:
tblItems
ItemID(AN)
ItemNumber

 I have a payroll database in design.  I have a few tables setup already
but am having a bit of trouble determining the design of the main 'Payroll'
table.  
I have an employee table and a payroll table.  The employee table contains

Each time I launch Outlook, the toolbars leave additional space and will not
stay locked where I place them before closing the Outlook application. Can
this be remedied?

In Access 2003, I am simply trying to create a few fields in which the only
data that can be entered into the field is "yes" or "no". I am hoping to do
this through my database field properties. (bound). For example, an employee
needs to know if there is signage at a job site, a ...

I need to know if there is a way to convert Numbers to Text ( ie. 12,345.00
to Twelve Thousand Three Hundred Forty Five Dollars and No Cents) .
Thanks,
MaryLou

Is it possible to add together the values in a column in a subform and
display them in another column in the same subform?