F
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
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