I have created a database in access 2002.  I am familiar with flat databases
but when it comes to relationships it goes right over my head.  I am trying
to organize a lot of people booking multiple hotels.  Each hotel has multiple
categories and only so many rooms for each ...

I have a DAP off of a table, that i added a search button to (code from
microsoft, see below) This works fine for the 1st DAP i did.
<SCRIPT language=vbscript event=onclick for=search>
<!--

I have two tables, one called Country with one field, country ID (e.g.
Philippines), the other called Province with several fields, but the primary
key is ProvinceID (e.g FIS which stands for South Philippines).
But a country can have two provinces, e.g. Philippines has FIS and ...

What I would like to do is link one table to another but have the second
table use a fields alpha/numeric info and add some alpha/numeric info to it.  
then I would like to have a third table use that new alpha/numeric entry and
add to it some more to keep everything linked in the ...

I work for a water distribution company and am faced with the task of
designing a database to analyze flows in the system in order to track water
rights and maintenance issues.  This entails about 30 sites with a flow total
for each day over the course of a year.  I want to be ...

Typical scenario 50 or so cabinets
Another key would be to have a cabling plan with barcodes relating to this
inventory.  Any suggestions?  No vendors please, this is a closed environment.

I'm creating an mdb for each state. I would like to export the table design
(but not the data) to another MDB so I don't have to re enter all the table,
fields, etc. I there an easy way to do this?

When I create a Form using the Forms wizard, if I select data from more than
1 table the form looks good in Design view, but is totally blank in Form
View.  Ideas??

     I'm trying to get a one to many relationship between four tables. Each
table is embedded within the other. The process I wish to accomplish is to
have my primary table with the primary key pull data from another table, the
linked table will then pull data from another table ...

I need some suggestions on how to store historical information at a point in
time for reporting.  Specifically, I am cleaning up a database for a customer
that tracks business opportunities. Each opportunity has a status such as
entered, in progress, on hold, win, loss, etc.  ...

I have users using a barcode scanner to scan different size barcodes into a
form.  This form updates the appropriate tables.  How can i take a field on
the form and only write back to the table the first 6 characters?
Thanks

I have a transaction database which contains individual tables for Supplier,
Purchaser, Bank, etc. User can add/edit information for these tables in their
respective forms. All the tables are linked to a table called
Transaction_Records (TR), which also contain a form for user to ...

I have two tables that periodically gets duplicate records, but I don't know
how that happens.
TABLE1 has a PRIME KEY, INDEXEX, NO DUPLICATES. It is NOT an Autonumber
field, and the value is programmatically created and checked if it exists

Hi -
Please keep in mind that I'm an amateur! :)
I'm am designing a database that allows users to match
their interests with places that they can travel to.  For