What we have is the following
A person comes in with a list of medications they need to take. It can be from one, up to around 13 to 15, depending on the person.
The same person can have one doctor, or multiple doctors, but usually one doctor.
We fill out an application for each ...

I am new to database design and have a basic question about how to set it up..
I am trying to create a database for media information.  There will be multiple contacts (reporters, editors, etc) from each company.  Is there a way to have the main company information remain the same ...

Where can I find, or does someone know, the maximum number
of columns and rows allowed in an Access Table?  Is there
a limitation on the size of a text file that can be
imported into Access?  Thank you in advance for your time!

I'm wanting to create an invoicing system in a database
that I have and have the need to send the items to a
different address than was billed to.
How do I set up the form so once I've entered the ship to

Can anyone tell me how to secure my database without using
passwords?
I would like to lock away all design access and the
database window. I only want access to the Main

We need to do a summary of columns in a Access Table.  I
cannot get it to "total" the number of entries when they
are alpha characters.  We need to summarize both number
and letters in a column of entries.

I have a database normalized as Duane Hookom's "At Your
Survey".
Now I'm finding that some of the data I'm using are long
text strings longer than 255 characters.

Hi I have an Auto Numbger Field...
I have some test records in the database to test...
How can I delete the test records and make the Auto Numebr
Field go back to 1??

When new fields have been added to a table, is it
possible to update an existing form automatically with
these new fields from the source table?

I need some help.. I am new Data base.. I want to create a
data base which have to enter 24 hours information and get
the average of latest 24 hours.
Any help will be appreciated.

I am rationalizing my business database to incorporate all addresses
(customer, supplier, reps, contractors, personal, freight etc) into the one
table system.
Given this, is it possible to do the same with the

Via the help of the MS-Newsgroups, I have done some table relationship design in the past.  Most previously, I designed
an architeture that uses a) multiple One-To-Many Relationships and b) a Many-To-Many Relationship (via Junction Table).
At this time, I am stumped again.  Below ...

Anyon
Seting up db to record race times and results for local swim club.  How do I format the time cell?  Need it to have minutes, seconds, tenths and thousanths of seconds

I tried to quickly scan most of the posts out here but
found bits and pieces of what I needed to ask.
I'm curious if anyone knows about some kind of table
manager that will show you all the queries, forms, etc

I need some help with table design.  Below is the structure of just a few
tables from a database.
There is a One-To-Many relationship between "tblCorrespondence" to
"tblCorrespondenceActionOfficer", and also a One-To-Many relationship