I have transferred a database from Bento and am having problems setting up a link-to-form relationship. I have a form called ‘Garden plants’ which includes a field called ‘Source’ which is currently a Pick List. I have a second form called ‘Nurseries’ which lists the source names. The first field is a Link-to-form/Many to Many with ‘Garden plants’ as the form to link to. My aim is to link each plant to the nursery that it came from so I can then go to the Nurseries form and see which plants I have bought from each nursery but the link is not working. What am I doing wrong? Is having the Pick List the problem? Thanks
Hello Catherine,
Have you enabled the “Show Inverse Relationship” checkbox on your Link to Form field? That will allow you to see the relationships in both directions.
And when you say the link is not working, exactly what do you mean?
Thanks!
Brendan
Hi Brendan
Yes I have ticked Show Inverse Relationships. Now some of the entries are showing up but most aren’t. Could it be that where I have entered the name manually it shows but when it comes from a Pick List, it doesn’t?
Thanks, Catherine
Hi Catherine,
Pick Lists and Link to Form fields are completely different things and have no relationship to each other. There’s no difference between selecting a value from a Pick List and typing that value into a field, whether there’s a Pick List associated with it or not.
It might be helpful to see screenshots indicating what the problems are.
Thanks,
Brendan
Hi Brendan
It’s ok – I’ve finally got it. I set up another relationship in a smaller database and saw what the problem was. I hadn’t realise that each link had to be made individually. I thought the link could be made via a field on the related form I had already set up which would recognise the supplier’s name. So it’s good news but also bad news because I now have 700+ links to make individually – unless there is another way you know??
Thanks, Catherine
Hi Catherine,
There’s no function to make the links automatically based on values in a form. This is something I’ve been wanting to do for a future update though. But that future never seems to come :-) It would be good to have though.
Thanks!
Brendan
.
