I am having trouble in getting my head round dates specifically employee
holiday dates where an employee has holidays booked for the year which are
added to and deleted from.
1. I need to allocate an allowance for existing and when sombody joins

I am constructing a data base for tracking referrals with in my department
and have hit a little bit of a wall.
Here's what i have to work with.
There are 2 areas operations and phones. Our operations area processes

I'm not getting my brain around this one.  The general situation is that
machine parts are processed according to a Process Plan.  A Process Plan may
be for one part or several.  Also, a part may be processed according to one
of several Process Plans.  These are the tables for ...

I want a field to contain a jpg image.  Help says to use the Attachment filed
when adding a new field (column.)  All I get are the standard
Text/Memo/Number... choices.  I'm using MS Office 2007 Pro.  All suggestions
will be greatly appreciated.

I need to keep records in an Access 2007 database that belong to one main
category and any number (in practice between 1 and 12 usually) of sub
categories. Currently I keep the main category as an integer and the sub
categories as a string which is a csv list, e.g. 1,3,5,7,9,11.

Can someone help me write a code that basically says this:
If [MyTxtbox] does not equal any value in [MyLstBox] Then
Msgbox "That value does not exist. Please try another value."
I need to have both the Listbox and the Textbox on my form, but I can't

Ok, in my Access 2003 database I now have 4 key skills tables;
tblEQUIPMENT - listing equipment iinformation (approx 250+ pieces)
tblMETHODS - listing analytical methods to use in conjunction with the
equipment from the EQUIPMENT table (approx 105 methods)

I wanted to see if I could get some assistance/recommendations regarding this
template. Our customers are states and we track dollars spent or contributed.
Would anyone be able to give guidance on how this template is structured or
anyone who has modified this template? I greatly ...

I would like to receive your feedback about my table design for forecast. The
forecast is set at product customer level.
What do you think about the following table layout in Access 2003?
ProductID

I have a ChildID table and a ClinicVisits table.  I want to ensure that the
user cannot create a ClinicVisits record that does not have matching values
for ClinicID and ChildID in the ChildID table.
When I try to establish a relationship in the relationships table, it will

I've been searching for the answer to this all week, and I haven't been able
to find it.  I'm new to building Access databases, but I've managed to do
pretty well with what I'm working on so far.  The one problem that is holding
me up from being done with this is that I have an ...

I'm trying to see if it is possible to have a table with a look up field
that updates all records when the linked table data is changed.
For example, we have categories in a separate table that is looked up in the
master table. If I change "graphic" to "graphics" and there are ...

I am going to try to repost my question and give all the pertinent
information.  What I really need is instructions on how to create a TWO field
relationship between tables to ensure that a user cannot enter a child record
that does not have a matching parent record.  

I am having some problems with a table in an Access 2007 database which
has an AutoNumber field to keep a record number.
It holds a record of various actions that will be required at the end of
each day and gets filled from a C# program using ADO.NET. The issue seems

When creating table, got error 3191.  All my field names were different. Why
error?