Table cell field to link to another form

Viewing 4 reply threads
  • Author
    Posts
  • February 3, 2023 at 5:18 AM #48825

    nickc
    Participant

    Hello,
    Is there a workaround for a field defined as a table of subfields where each cell call link to another form?

    For example, two forms, one form has a field set up as a table with 6 columns and user defined number of rows. Each cell field to have a 1 to many link to records in a second form. Unfortunately when you look at the field type options for each cell the 1 to many and many to many link options are not available.

    Hope this makes sense!

    Thanks
    Nick

    February 4, 2023 at 3:20 AM #48830

    Brendan
    Keymaster

    Hi Nick,

    The Table field is pretty much self contained within the form it belongs to. It doesn’t support linking out to other forms.

    That’s what the Link to Form field is for.

    Thanks,

    Brendan

    February 4, 2023 at 3:33 AM #48832

    nickc
    Participant

    Hi Brendan,
    Many thanks for the explanation.

    Thanks again for a great piece of software, just going through a phase of linking everything to everything!

    Nick

    February 5, 2023 at 3:36 PM #48843

    Brendan
    Keymaster

    Don’t get too carried away with that or you could end up creating circular references.

    E.g. Form A links to Form B which links to Form C which links to Form A.

    It can make exporting data tricky or possibly get into an infinite loop situation.

    February 5, 2023 at 11:35 PM #48848

    nickc
    Participant

    Good point, thanks !

Viewing 4 reply threads

You must be logged in to reply to this topic.