Dec 31st, 2016, 12:04 PM
(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!