+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: many-to-many join table? (/showthread.php?tid=18679)
many-to-many join table? - Jan Steinman - Dec 19th, 2016
Is there a tutorial on doing a "join table" implementation?
This is the case for representing "many-to-many" relationships, for example, where a product can be found in many stores, and a store can carry many products.
In SQL, this is conventionally implemented in a "join table," which contains pairs of IDs into the store table and the product table.
I have a feeling this is done using "views," but reading through the view documentation did not get it into my thick head...
Thanks in advance for any help offered!
Jan
RE: many-to-many join table? - Jan Steinman - Dec 31st, 2016
(Dec 19th, 2016, 6:41 PM)Jan Steinman Wrote: Is there a tutorial on doing a "join table" implementation?
No replies, so perhaps I did not explain well enough.
A classic example might be an invoice or sales order, which consists of per-invoice information, and per-item information.
This might be represented by a table for invoices, and a table of invoice line-items that point back to the invoices they belong to.
In my particular case, I am doing a farm production survey. It will ask a number of simple questions of farmers ("How many acres under production?", etc.), but also several variable-length questions, such as "What crops did you grow? List cultivated area and weight of harvest for each." I would normally implement such a thing as a "survey" table for each farmer surveyed, and a "crops" table for the variable information, with each record pointing back to a survey table entry.
How would one go about doing such a thing in Form Tools?
Thanks for any advice offered!
RE: many-to-many join table? - jiuer7845 - Aug 26th, 2021
Nike Air Jordan
Jordan Shoes
Jordans Shoes
Yeezy 350 V2
Adidas Yeezy
Yeezy
Yeezy 700
Yeezy
Nike Outlet
Yeezy Shoes
UNC Jordan 1
Jordan 13
Jordan AJ 1
Yeezy Foam Runner
Nike Outlet
Nike Outlet
AJ1
Yeezy Supply
Yeezy Zebra
Jordan 1 Low
Air Jordans
Pandora Charms
Adidas UK
Nike Store
Adidas Yeezy Official Website
Yeezy 350
Jordan 1
Nike Outlet
YEEZY SUPPLY
Pandora Charms
Nike Shoes
Nike Outlet
Pandora Outlet
Jordan Shoes
Air Jordan 4
Pandora Jewelry
Pandora Rings
Pandora Bracelets
Adidas Yeezy
Yeezy
Pandora Charms
Nike Outlet
Adidas Yeezy
Air Max 720
Nike Air Max 270
Air Jordan 11
Air Force 1
Air Jordan 1
Nike Jordans
Jordan 1s
Pandora UK
Nike Jordan 1
Jordan 1
Yeezy Slides
Nike Air VaporMax
Nike Vapormax Flyknit
Air Jordan 1 Mid
Adidas yeezy
Yeezy Shoes
Adidas Yeezy
Yeezy 350
Nike Shoes
Nike Outlet
Yeezy
NFL Shop Official Online Store
Nike UK
Yeezy
Yeezy 350