I have entity Product. I want to create BOM (Parent and Child).
I took both parent and child in one table and tried to connect with those
with the Product Index but only one of those(parent and child) could be
connected.How should I do this?

I have a DB with one OLE field, linking to BMP image files, the images are
NOT imbedded.
I have loaded links for about 35 records, but when I try to add another link
(there are 175 recs total to be updated with link to the image file) I  get

I have a MedService table with 20 fields (FluVac, dental, Smokeed, FootExam,
……)
I need to add for each one of these fields another 2 date fields
(CurrentDate, NewDate)  .

When ceating a database and setting validation rules for a text field where
the required value is either: living area or study or bedroom so access
accepts this in the validation rule as "living area" Or "study" Or "bedroom".
When now importing a csv file were this field contains ...

I have an existing database that my client gave me. They want pull-downs for
some fields (lookup tables) and forms created using the new design.
One of the columns they want is a memo field due to the amount of
information they have for that column. Apparently, you can't have a ...

I need a database that can accomadate continuous import of session notes, a
weekly imput which may go on for several years. AS well as the usual contact
information,,dob, etc any templates already out there?

background is:  Job>Product>Tickets.  This has to be further broken down for
one particular customer because we are having to stockpile the product at
various locations, ie:  500 tons of # 6 stone at site A, 300 tons # 6 stone
at site B, etc.  I have to track how much material is ...

I'm seeking help that will enable me to create a query that will search four
different fields and place the data in descending order into one field.

I ended up adding a bunch of fields to a table with many of them using
duplicate information (Street Name, City, State, etc.), so I used the Table
Analyzer to "normalize" the table.  Everything split fine, but now if I
change a value in one record, it changes them all.  I also ...

When creating an input mask for a field when using it, it does exactly what
it is suppose to do.
However when importing data from another file (csv or excel) the values in
this field that are correct but in the wrong case get rejected despite the

How important is it to split an Access database into > 1 table?  Is it
necessary?

One of the requests from my client is to be able to auto-fill a record using
a pull-down list of pre-determined information. I have no idea how to proceed
with this so any comments will be appreciated.

How can I set up a database to track and log our training departments
facilitation hours?
I am using Access 2000

I have a yes/no field and a text field.  I want the text field to be null if
the yes/no field is no and required of the user to enter data if the yes/no
field is yes.
I hope this is clear enough.

This should be something easy to do, but I'm running into trouble. I have one
"Master List" (table) of data. These are the names and addresses of
individuals. These individuals also belong to a Christmas list, a Volunteers
list, or a Provincial list, sometimes all three!