Related Data HELP!!1
Hi i am building a database to keep track of projects on which i need to have the option to choose what composers wrote music for that specific project. I have all the composer information in a separate table and i would like to have a field in the "Projects" table that lets me add 1 or 10 composers and all their information to the record.... I know this feature is called related data in bento where you can make a table that pulls info from another library...
You need a third table called a Join table.
This blog has 3 articles on Join Tables...which includes an explanation of how to set it up.