Link To Entry field: Difference between revisions

Link To Entry field (view source)

Revision as of 22:17, 25 August 2016

1,085 bytes added , 25 August 2016

m

no edit summary

UnConnoisseur

Write, Bureaucrats, Administrators

4,332

edits

@@ Line 42: / Line 42: @@
 == Examples ==
+For each of these scenarios, there are many templates in the online template catalog &mdash; perhaps to use with little or no customization &mdash; or perhaps to study and learn their techniques before implementing your own.
+=== Tracking spending on groceries
+In this scenario, we shop at grocery stores at certain dates/times (receipts) and buy grocery items.
+; We visit stores to shop for groceries.
+: Create a one-to-many Link To Entry field within library Grocery Receipts to library Stores. Grocery Receipts contains fields for date/time, payment method, etc. Stores contains contact information, location, etc.
+; We buy grocery items during visits; the items appear on receipts.
+: Create a one-to-many Link To Entry field within library Grocery Purchases to library Grocery Receipts. Grocery Purchases contains fields for the brand, variety, item, units, quantity, category, etc.
+Slice & dice within the Grocery Purchases library.
 === Commercial product sales ===
 In this scenario, one or more companies each has its own products and customers.
 When an order is taken, multiple of the company's products may be sold, each of which will be a line item on the order.
-; Companies have products
+; Companies have products.
 : Create a one-to-many Link To Entry field within library Products to library Companys. To allow companies to share products, make it a many-to-many relationship.
-; Companies have customers
+; Companies have customers.
 : Create a one-to-many Link To Entry field within library Customers to library Companys. To allow companies to share customers, make it a many-to-many relationship.
-; Customers place orders
+; Customers place orders.
 : Create a one-to-many Link To Entry field within library Products to library Customers. It doesn't make sense for multiple customers to collaborate in placing an order.
-; Each order is for one or more items, each for a quantity of a product
+; Each order is for one or more items, each for a quantity of a product.
 : Create a one-to-many Link To Entry field within library Order Line Items to library Orders. An line item belongs to exactly one order.
-; Products are sold via orders as line items
+; Products are sold via orders as line items.
 : Create a one-to-many Link To Entry field within library Order Line Items to library Products. Each line item is for a product.
-=== Academic departments, courses, instructors, students, classes ===
+Slice & dice mostly within the Order Line Items library.
-In this scenario, one or more academic departments employs instructors, offers courses, admits students, schedules classes taught by instructors and attended by students ===
-; To establish a many Departments to many Instructors relationship
+=== Students taking classes ===
-: Create a many-to-many Link To Entry field within library Instructors to library Departments
-; To establish a one Departments to many Courses relationship
+In this scenario, one or more academic departments employ(s) instructors, offer(s) courses, admit(s) students, schedule(s) classes taught by instructors and attended by students ===
-: Create a one-to-many Link To Entry field within library Courses to library Departments
-; To establish a one Departments to many Students relationship
+; Instructors work for one or more academic departments.
-: Create a one-to-many Link To Entry field within library Students to library Departments
+: Create a many-to-many Link To Entry field within library Instructors to library Departments.
-; To establish a one Instructors to many Classes relationship
-: Create a one-to-many Link To Entry field within library Classes to library Instructors
+; Courses are offered by an academic department.
-; To establish a one Courses to many Classes relationship
+: Create a one-to-many Link To Entry field within library Courses to library Departments. To support interdisciplinary courses, make that a many-to-many relationship.
-: Create a one-to-many Link To Entry field within library Classes to library Courses
-; To establish a many Classes to many Students relationship
+; Students enroll to be eligible for classes.
-: Create a many-to-many Link To Entry field within library Students to library Classes
+: Create a one-to-many Link To Entry field within library Students to library Departments. Let's say they pick a major in some department.
+; Instructors are assigned to teach classes.
+: Create a one-to-many Link To Entry field within library Classes to library Instructors.
+; Classes are offered for particular courses.
+: Create a one-to-many Link To Entry field within library Classes to library Courses.
+; Enrolled students register for certain classes.
+: Create a many-to-many Link To Entry field within library Students to library Classes.
+Slice & dice mostly within the Classes library.