Topic: Question about master detail records
Hi, I was looking through the example databases for one that implements master detail style records. How can you do this without using scripts.
Scenario: I have a number of records that have several fields, and I want to arrange them into collections such that a given collection consists of some information unique to the collection and then it will contain one or more of the item records. Each item record should be viewable separately outside of the collection, but may be part of one of more collections.
In the phone example, adding a new detail record is possible, but there is no examples anywhere of linking to a pre-existing record, you only seem to be able to add new ones.
Traditionally, I guess what i need is a many to many relationship using a join table, but I dont see how to implement this without writing script code.