Hi,
I have a form in my canvas app in which the user submits details to a table (TABLE A). On the form there is a lookup field to a project table (TABLE B) . The project table is linked to a 3rd table (project field is a lookup field in TABLE C) where projects can be allocated to a user (TABLE C).
I need to be able to filter the lookup Field in TABLE A to show only the projects allocated to the user in TABLE C. I can do this using a lookup in a gallery and then referencing the selected item but this only returns the first result.
Any advice please?
Many thanks,
