i had designed a front end for marking attendence by simply clicking
comboboxes for 52 students. i require a report in following format and
the design of the tables for this students.
The format is:

I have an employee table which has unique employee ID as primary key.
I need deal with another table and infromation using Login ID which the
system re use the login ID after employees left
There are some solutions for this, but I am not sure which one is the best.

I want to build a relationship between a query and a table.
MS Access allows me to create a text(4) in the query and an integer field in
the table.
Does it make sense for this?

I have a form that was designed in a previous version of Access and I need to
change properties to one control in that group. The properties box omly shows
"Multiple selection". Can I ungroup them in Access 2007?

I'm getting weird problems in Office 2003 SP3.
The first one is simple to reproduce.
1) Create a new blank database.
2) Add a new table "Table_1" and add a field. Doesn't matter what either are

Are there any issues in having a date/time field as my primary key? thanks.

Is there a backup utility or Ad-In that will back up my db and save only
say,
3 backups. I use the backup in Access 2007 but I need to go to the backup
folder

I have tables that are deleting "backwards". For example tblA is the
parent of tblB and tblB is the parent of tblC. When I delete a record
from tblC (through its form which is a subform) it cascades back and
deletes the parent record in tblA. I've never encountered this before.

I am trying to create a database for entries for a dog show the following is
how I have set it up so far
TABLE - DOG_DETAILS - Fields - Registered Name, Breed, Sex, Date of Birth,
Breeder, Sire, Dam, Class_1, Class_2, Class_3, Class_4, Class_5

I have following tables
tblcoursepayment  with autonumber invoice number field.
tblitemSalesPayment with autonumber invoice number field.
how can I generate a central sequence invoice number for both table?

I am using Access97 and I currently have a db that I use to record the pages
I receive from remote sites but I am currently using a combination of check
boxes for the pages and text fields to record subpages received.
i.e. pages 1,2,3,4,5,6,7,8,9,12 Subpages 10-01, 10-02, 11-01  ...

Add a Recycle Bin tab that will contain each table of Access and the deleted
records of those forms
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

I have inherited 9 stand alone databases that need to be merged into one
package.
The problem is the auto number it is the primary key and unique Identifier
for aprox 20 tables in each database. Each database structure is identical so

I have my database built and I'm experiencing one problem that I can't seem
to get to the bottom of. I have a Form and on this form I have a combo box
where you would select an Individual employee to where you would only see
that individuals information on the report. But the ...

I have created a Form from a table.  The form is formatted the way I would
like.  I have several other tables that I would like to change to Forms but I
would like to use the same format from the 1st Form without having to
manually format it.  Is there a way to use this format ...