Table cell field to link to another form

[nickc]

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

[Brendan]

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

[nickc]

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

[Brendan]

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.

[nickc]

Good point, thanks !

[Author]

Posts