need help with setup of tables

[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

 

[John W. Vinson]

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.

Use a Form based on the Location table, with a Subform based on the events
table. Use the primary key of the Loction table as the "master link field" of
the subform, and the related field (a Long Integer if the primary key of the
location table is an autonumber) as the Child Link Field.

You'll probably also want a small table of the nature of the activity, and use
a combo box on the subform to select one from a list, rather than just typing
them in (more work and prone to misspellings).

John W. Vinson [MVP]

 

[firecop1]

Thank you sir, took your advice..

Use a Form based on the Location table, with a Subform based on the events
table. Use the primary key of the Loction table as the "master link field"
of
the subform, and the related field (a Long Integer if the primary key of
the
location table is an autonumber) as the Child Link Field.

You'll probably also want a small table of the nature of the activity, and
use
a combo box on the subform to select one from a list, rather than just
typing
them in (more work and prone to misspellings).

John W. Vinson [MVP]