am working now on one database where i have 5 tables, each record from one
table is related to one another in other table with One to Many Relation
in other words, each record from one table may has many records on the next
table

Good Afternoon,
    I have a very basic question regarding the organization of my table. I
will have monthly data that will be entered and it will be for various years.
Is it better to use one field called month and do a crosstab query or should

Hi,
I am working on a database in which I need to be able to use a cmd button to
populate a new form but I need to be able to add many records from the
initial form in order to do so.

Thanks to this forum I have made some headway. Again I am stuck.
table1 with 50 names and staff code.
table2 with 100 items, price and stock.
With the forum guide managed to make a table3 with one field as looku

I am using Access 2007.  I have a db with 2 tables (employees, discipline).
The tables are not joined because i keep getting the error that there is a
mismatch in the data. There is a common field (employee #) in both tables.  I
need to design a form that shows an employee and ...

I'd like to create a client/server application where multiple users can
read/write access a single table, each user accessing a unique portion of the
table. If I create a link to the table in each copy of the client database,
would there be a problem with multiple simultaneous ...

I'm trying to set up a client/server application where multiple people will
be simultaneously editing a single table. (Each user will be restricted to
only those records belonging to him and there should be no overlap).
I know how to create the client and server pieces but I'm not ...

I have two tables in Access 2003, Master (Parent) and Hours (Child).
Currently they share a One-To-One relationship. I need a record to be created
in the Hours table every time there is a record created in the Master Table,
but when users don't enter a vaule in the Hours table, ...

Okay, so I'm using Access 2000 and I'm not a programer so please speak in
plain english.  I have a table of all donations made and a table of all
checks cut out of our program.  The relationship between the tables is an ID
if applicable and in some cases a donation key.  Some, ...

I am creating a DVD Movie Database using the template on Microsoft Office's
Web Site. My question is this and please correct me if I am wrong. It seems
to me that if you have a DVD of a television series that also has seasons as
well as episode numbers-assuming that the ...

Can you guys point me towards some good resources to help me make a database.
I want it to be able to search by provider # and name. Each person will have
name, provider #, ss # and a big comments field. I don't want anything fancy
right now just something that works and is ...

I am working on an archival database of media materials related to the
accomplishments of a non-profit group. One section of the database is devoted
to articles. I have a series of tables separated into types of articles
(Newspaper, Magazine, Blog, etc.) For this question, I will ...

Please help.
I have created a form with a subform. I have a 2 combo boxes in the subform.
When I choose an option on the 1st combo box it restricts the choices
through an SQL query on the other combo box.

i know in the back of my mind i know how to do this but...
when i select the suburb in the lookup field i need the table to
automatically update the postcode and state field from the lookup table -
like a vlookup function in excel

I want to have an autonumber ID number assigned to every entry, however is it
possible to recognize when the name is repeated and put the original ID
number in without having to do this all manually?