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: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
Sent: Wednesday, August 07, 2013 5:24 PM
To: MS_Access_Professionals@yahoogroups.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
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar