I am seeking ideas/samples/templates on designing a DB where I can catalog film cartridges and the individual frames taken.  For example:  Cartridge # 0001 is a 24 exposure roll and frames 1 through 6 are taken by one individual, frames 7 through 18 by another, and frames 19 ...

i have telephone numbers stored into TelphNum.TelphTable ,
in according to telecome company , numbers will be updated
by adding additional ziro after the second digit ,
for example :   456862321  will be convert to :  4506862321

Help, Help, I can't stop access from changing data, in
saved form generated records, when I update the table used
for my combo box selections on the form. I've tryed
changing the bound coloums to avoid using the list index,

I have a project for work in which I am trying to create a
database to put student information in.  In the process I
have hit a snag.  I have a table named "Renewable
Certification" and in that table there is a field

An Access app has a table named tlkpReason that looks up
values for a table named tblReasonperCase that is linked
to another table named tblInquires.
The tblReasonperCase table has two joined primary keys

I have a table which updates with information from
another database program.  Six fields in the table store
numeric values eg : Item1 220.00 Item2 22.00  and so on.  
There is then a total field that stores the total of

I have a table with over 1000 monetary values that I need to increase by
15%.  Other than manually caluculating all the new prices, is there a way to
add 15% to the existing field/value?
Thanks for any suggestions.

I have a table with 4 sets of grandparents (grandparent1
info, grandparent2 info, etc.).  I really want 4
autonumber fields but I know Access won't allow that.  
How can I get grandparents1 to have an "autonumber"

I wonder if anyone out there can help me.  I have an SQL
database with an Access 97 front end that is used as a
call logging tool for an IT Helpdesk.  The call logger has
been in use for roughly six months without any problems,

Im kinda new to all this, have a question.
Can a table have more than one relationship on one field,
ie
I have a main table called tblmain, with linked relation

I am in the process of putting together an access
database. One of my tables is comprised of data that will
be downloaded from another program on a fequent basis.  
Ideally I would like to import the new data and have it

I have an Access 2000 database that I am using for a .asp
page on a web site.   I am using a Memo field but it will
only let me have 65,000 characters.  The help file tells
me: "Up to 65,535 characters. (If the Memo field is

I am trying to set up a small database which can book people onto tours.
There may just be a single person attending himself or he may come along as
part of a party (ie a family unit, group of friends etc).
I am not totally sure how to design my tables. If I just set up a passenger

Is it possible to populate a table with links to files in
folders?  in otherwords...  i want to connect a folder to
a table, so that the table will hold the name of the file
and link to the file.    also will it recognize new files

I have a data base which has look up tables that have more than one field in their primary key
ie
lookup table GROUP
stateid, groupid, groupdesc primary key is stateid, groupid