Back again - building permit form

[ksr]

I am currently setting up a Access 2000 database that will track
property in regards to building and plumbing permits, shoreland zones,
subdivisons etc.. I have the following major tables setup as follows:

Owner Table
*Field*
Name OwnerID (Primary key- autonumber)
Lastname
Firstname
Street
City
State
Zipcode
Telephone

Property Table
*Field*
PropertyID (Primary key- autonumber)
OwnerID (foriegn key to OwnerID - OWNER Table)
CurrentOwnerLastname
CurrentOwnerFirstName
PhysicalAddress
TaxMapLotNumber
DeedBookPageNumber
Acres

(Juntion table for the many to many relationship between owner and property
created at the table level)
LINKProperty_Owner Table
*Field*
PropertyID (composite foreign primary key)
OwnerID (composite foreign primary key)

BuildingPermit Table
*Fields*
BuildPermitID (Primary key- autonumber)
PropertyID (Foreign key to Property Table PropertyID
DateFiled
ApplicantLastName
ApplicantFirstName
ApplicantAddress
ApplicantCityTown
ApplicantZipcode
OwnerLastName
OwnerFirstName
OwnerAddress
OwnerCityTown
OwnerZipcode
TypeOfStructure
PlumbingPermit
OwnerOccupied
DeededRightOfWay
DistanceFromPropertyLines
etc...etc

BuildingPermitDetails Table
*Fields*
BuildingPermitDetailsID (primary key autonumber)
TypeOfApplication
ApplicantID (foreign key to Applicant table-ApplicantID)
ActionTaken
DateOfAction
etc...etc

PlumbingPermit Table
*Fields*
PermitNumber (primary key text value)
ApplicantID (foreign key to Applicant table-ApplicantID)
TypeOfSystem
DateOfAction
SepticTankSize
SepticFieldSize
SepticSystemAge
ActionTaken
DateOfAction

Applicants Table (sometimes different than owners- ex. family members)
*Fields*

ApplicantID (Primary key- autonumber - Parent key to
PlumbingPermit BuildingPermitDetails tables corresponding keys)

Lastname
Firstname
Street
City
State
Zipcode
Telephone

I have setup forms for owners and properties based on their corresponding
tables for update/add/re-assign owners to properties. This seems to be
working fine.

What I would like to do next is to setup a building permit form that the
user would be able to select/add applicants, owners and properties along with
its building permit fields and details (re:- building permit details) I am
not sure how to approach setting this building permit form in regards to
using all the information. I have looked into designing the form based on a
query and utilizing subforms but still getting no where and need some
direction or hints.

Any ideas would be helpfull and much appreciated as always.

 

[Tom Willett]

You should post in an access newsgroup. Office Update is for
questions/problems pertaining to performing security and other updates for
Office.

 

[ksr]

Sorry Tom,

I thought this post went to the Access forum ?
Weird ?