Use a portal to update a table?
I'm new to FM but have built some basic databases using MS Access. I'm using FM Pro 11 Advanced and FM Go (iPad).
I'm struggling to get my head around Portals, as I'm unsure how to use them to update tables. They look great for updating related data though. I have the following structure so far:
The Relationship is 1-Many from SITES to ARCS. 1 site can only have 1 arc but each arc can have many sites.
In the Sites form, I want to select a 'company' from the 'ARCS' table using a drop-down list. This action should then copy the _kp_arcs_id into the _kf_arcs_id. Then, a portal would show the 'address', 'city' and any other data fields from the relevant ARC entry.
Is this possible? Any tips/suggestions on how to achieve this would be great, many thanks...