ACCESS FEED: Re: [MS_AccessPros] Better structure maybe?

Rabu, 07 Agustus 2013

Re: [MS_AccessPros] Better structure maybe?

The note table are pretty standard across each field.

Eg.

UnitNotes
UnitNoteID PK
UnitID         FK back to Unit table
Subject
Description
CategoryID FK to NoteCategory lookup table
Photo          Image if applicable
EmployeeID FK to Employee table
LogTime

this is the standard layout for each of the note tables
ExteriorNotes
ExteriorNoteID PK
UnitID         FK back to Unit table
Subject
Description
CategoryID FK to NoteCategory lookup table
Photo          Image if applicable
EmployeeID FK to Employee table
LogTime

And so on and so forth. There can be many notes per primary table

So the Unit table can have multiple records in the UnitNote table.

With Warm Regards,

Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
alorenzini@crhanetwork.org
"Only those who will risk going too far can possibly find out how far one can go."

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, August 7, 2013 9:59 AM
Subject: RE: [MS_AccessPros] Better structure maybe?

Art-

What is the relationship between the two sets of table? For example, are
there many records in UnitNotes for each Note record, or just one? What
fields are in the "notes" tables?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: mailto:MS_Access_Professionals%40yahoogroups.com
[mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of Art
Sent: Wednesday, August 07, 2013 5:24 PM
To: mailto:MS_Access_Professionals%40yahoogroups.com
Subject: [MS_AccessPros] Better structure maybe?

I have a database with the following tables:

Unit
Exterior
Structure
Utilities
...

Along with these table I have the following tables that include notes and
images about each of the primary tables:
UnitNotes
ExteriorNotes
StructureNotes
UtilitiesNote
...

As I was going through this I am thinking there has to be a better design
than separate note tables for each of the primary tables. Any thoughts?

Thank you

Art Lorenzini
Sioux Falls, SD

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]