I have 3 production tables, A, B, C.  Each has a PK, to act as parent fields.
( I have 3 production tables b/c each table stores diff types of info for the
diff items.) I have another table where the quantity of each item made is
stored (this is done so I can do a calculated ...

I need a Bill of Material template. I have built everything but this in
Access 2002.
Can someone please help me?

I would like to know if MS Access can handle the following problem and if I
could get a few pointers on how to tackle this situation.
Problem Description:
- I have a table which describes a series of Items (e.g. ItemID (PK),

I need help as soon as possible so as to save a copy

OK I read through every post I can find; however, I do not believe anyone
else has tried to do what I am doing.  I need to export records with more
than 255 fields to excel.  To do this it has to be vertical.  I am merging 3
tables into one export file.

How can I  attach images (in a folder) to a record and launch the image
viewer from Access to view the images?  Is there a Microsoft image viewer
application for this purpose?

Can I have a composite key and link it to a foriegn key which also is a
composite key? I have tried it, but when I'm trying to add referential
integrity to the link I get the error "No unique index found for the
referenced field of the primary table." What is the error, in other ...

I have a small publishing company that I am trying to create an inventory and
order/invoice database.  I was hoping to use the Order Entry template from
microsoft.  I have some understanding of tables, queries, and forms, but not
sure how to tie in an inventory piece so that I ...

I am having to import demographic records where the first and last names are
in one field.  I know how to separate the first and last names by using a
search and replace operation to insert commas, then exporting the records to
a text file and re-importing them, but is there a ...

Hi.  I know that this is possible, but I can't seem to get it to work.  
I have a table called "House Plans", which has, among other things the Plan
number (the Unique key for the table), the Description and the SqFt.  
I have built a query - "House Plan Description Query".  In ...

I have tried installing the jpg filter from the Office XP CD to display the
contents of my OLE field in a form, but I still can't see my pictures!

Looking for some guidance on setting up a database for performing some metric
calculations.
This data consists of the following:
LTL Orders

I want to add a database to a website created with FrontPage2003. The
database will eventually accomodate between 5000 to 10,000 records. Users can
update online (add, delete, change. Do you recommend using FP2003 to do this
and if so, what is the best approach to take. Our site ...

I have two tables (Movie and Categorie) witch I want to link together.
Movie                                           Category
Nr (PK)            Number                Category (PK)            Text
Titel (PK)          Text

I want to start a database with a switchboard showing various users and have
them click their name to go to their own switchboard. I know how to set the
startup form but can't find the full screen start up setting. Also, can you
set each subsequent user's switchboard form to ...