one-to-many/many-to-one

  • CJW

    (@cjw)


    10 months ago

    Hi, I have set up a numeric field [grade] into which an inspection grade is currently appended through the upload of a CSV file into PDB. This works fine and as expected. The grade being displayed on the member profile record.

    What I would like to do is maintain a history of grades within that field so that each time a new grade is appended to a record, the list of grades can be displayed.

    Previously I’ve used Airtable to do this using two separate tables [grade] & [members]and where when a grade was entered into the [grade] table, a linked field in the [members] table is updated/appended with that new grade, the field showing the historical grades.

    I believe this is either a 1:many or many:1 type relationship and wanted to know if this was possible in PDB with the relationship plugin?

    Thanks!

    CJ

    • This topic was modified 10 months ago by CJW.
Viewing 1 replies (of 1 total)
  • Plugin Author rolandbarker

    (@rolandbarker)

    10 months ago

    For something like, this, I recommend the Participant Log plugin, which adds a field that keeps a list of entries for a record. This is strictly one-to-many in the sense that the log entries belong exclusively to the record.

    The Multi-Relational plugin can do both many-to-one and one-to-many, but from your description, it will introduce more complexity than you need.

Viewing 1 replies (of 1 total)

The topic ‘one-to-many/many-to-one’ is closed to new replies.