difficulty with a relationship/subform

[firecop1]

Hi all,
I am new to Access 2007 and need to create a very simple database to track a
location and any activity(s) that happen there.

I am guessing that I need a table to store the name, address and phone
number of the address then another table to track the date of activity,
nature of the activity and a memo field. I would like the information from
the first table to be on top of a form and the info from the second table to
be a subform where I can see all of the activities.

I know how to make the tables I just dont know how to join them so it
filters the activities shown on the form to the address shown on the form.

Any and all help would be greatly appreciated

AJ Brofman
Chief Fire Marshal
Lake Grove, NY

 

[Arvin Meyer [MVP]]

One of the true beauties of Access and the use of bound forms is the
automatic linkage that the Wizards perform when building forms/subforms. All
you need to do to make it easy id create the form and subform, then open the
form in Design View and use the subform tool in the design toolbox to add a
subform. The wizard will take you through the rest. AAMOF, if you don't have
a subform, the wizard will assist in creating one for you.

 

[firecop1]

So I should create my two tables. What is the field that I will use to link
them (I am guessing it is a one to many relationship).
Then I create two forms-one for each table?
Then I use the wizard to add the subform?

I know this is very simple but I am not that good yet so I need a bit more
explaination if you wouldnt mind

Andy

 

[Arvin Meyer [MVP]]

Yes that is exactly correct. Use the Primary Key from the One side of the
relationship as a Foreign Key on the many side.

There is a demo with the Orders/Order Details tables and forms in the
Northwind sample database that came with Access:

Help >>> Sample Databases >>> Northwind.mdb
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[firecop1]

Thank you Arvin, it worked like a charm....a very nice feature in Access.

Take care

Andy