many-to-many join table?

[Jan Steinman]

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

[Jan Steinman]

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!

[jiuer7845]

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