I'm a javascript developer, but all the examples I can come across are either too nuanced or specific for my needs, so I'm hoping to find a simple script to take the following table which has a column of linked records from a third table:Table_1IDLin...
This may be the wrong category, but I need to join two tables for output of our data. I have two linked tables:
Person and Classes
The person table looks like:
Name | Classes
----------------
John | A,B,C,F
Sally | B,F
Max | B,C
While the linke...
I have a table of people called “Roster”
Roster:
Mark
John
Sue
Betty
Which has some good information.
What I would like is a second table with the same rows:
Mark
John
Sue
Betty
That has different columns… and any time a new row is added to the Ros...
I have a supply chain I’m looking to keep track of:
Growers
Processors
Wholesalers
Markets
These are all listed in my “Entities” table with a “Type” field distinguishing them.
Now, I’ve figured out how to link single-steps using a relationship table...
Thanks for the help, but I’m a little confused:
Assuming I already have the structure above with thousands of records (I do), is there a way to easily convert to the structure you suggest?
How would this work when inputting data? The convenience of...
Absolutely necessary.
Just re-built my entire Base (again) because working around this missing feature became such a tangled mess since I can’t have categories with entries that link back other entries in different categories in the same table.
EG:
P...