Great message -- plus you made me laugh!
"Hippocracy Now!" -- what a hoot!!!
Fairfax Public Access
Fairfax Cable Access Corporation
FPA Channnel 10/WRLD International 30/WEBR Cable Radio 37
2929 Eskridge Road
Fairfax, VA 22031
571-749-1100, ext. 1110
----- Original Message -----
From: "Jordan" <jor...@gmail.com
To: "Facil Software" <fa...@googlegroups.com
Sent: Thursday, December 03, 2009 10:27 PM
Subject: [Facil Discussion Group] - Re: Tracking Organizational Use
Paraphrased from many Internet locations.
The one-to-many relationship is the workhorse of relational databases
as well as being the easiest relationship to understand. One-to-many
(also known as "to-many") relationships are often used when managing
databases. A one-to-many relationship occurs when one entity called a
PROJECT is related to many occurrences in another entity called
PROGRAMS. For example, one school has many students, one access
center has many members or in Facil one PROJECT has many PROGRAMs.
A one-to-many relationship allows records in the PROJECTs Table to be
connected to an arbitrary number of records in the PROGRAMs Table
without the limitations imposed by resorting to redundant or limited
numbers of fields.
There is no difference in Facil between an episode and a PROGRAM.
They are one in the same, they are identical.
There is A NEED to create multiple PROJECTs for unrelated PROGRAMs.
There is NO NEED to create multiple PROJECTs for related PROGRAMs.
In this instance a PROJECT is a cookie cutter or rubber stamp that
eases filling out the data fields.
Think of it like this.
Access USA receives a series: "Censored SpeechTVï¿½ from the
ORGANIZATION "Hippocracy Now!"
Following these steps:
A - Create ORGANIZATION record: "Hippocracy Now!"
Optionally you can relate or create a ï¿½relationshipï¿½ or link between
an ORGANIZATION to an existing PERSON Record.
B - Create PROJECT Record: "Censored SpeechTV"
C ï¿½ Use the Drop down Box to Create a "1 to many relationship" between
the ORGANIZATION Record: "Hippocracy Now!" and the PROJECT Record:
D ï¿½ Create PROGRAMs: "Censored SpeechTV"
Censored Speech ï¿½ Iï¿½s wide Shut | 1
Censored Speech ï¿½ Talk to the Hand | 2
Censored Speech ï¿½ Oh No You Didnï¿½t | 3
All of a sudden out of nowhere the ORGANIZATION: "Hippocracy Now!"
produces a cooking PROGRAM: "Liberal Grill"
B - Create PROJECT Record: "Liberal Grill"
C - Use the Drop down Box to Create a "1 to many relationship" between
the ORGANIZATION "Hippocracy Now!" and PROJECT Record: "Liberal Grill"
D ï¿½ Create PROGRAMs: "Liberal Grill"
Liberal Grill ï¿½ Steak | Episode 1
Liberal Grill ï¿½ Fried Onions | Episode 2
Liberal Grill ï¿½ Baked Arizona | Episode 3
Each show produces 1 or many PROGRAM episodes.
The ORGANIZATION is >related< to the PROGRAM by way of the PROJECT.
The PROGRAM is >related< to the ORGANIZATION by way of the PROJECT.
By design databases have different areas for data entry. This is the
important part: The only way PROGRAMs: "Censored SpeechTV" and
"Liberal Grill" are related is by the ORGANIZATION: "Hippocracy Now!ï¿½
"Censored SpeechTV" and "Liberal Grill" do not mix but they each stand
alone, mutually exclusive from one other.
You received this message because you are subscribed to the Google Groups
"Facil Software" group.
To post to this group, send email to fa...@googlegroups.com
To unsubscribe from this group, send email to
For more options, visit this group at