AnsweredAssumed Answered

Use a portal to update a table?

Question asked by brian.curran on Feb 27, 2011
Latest reply on Feb 28, 2011 by brian.curran

Title

Use a portal to update a table?

Post

Hi,
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:

ARCS
_kp_arcs_id
company
address
city

SITES
_kp_site_id
_kf_arcs_id
company
address
city

The Relationship is 1-Many from SITES to ARCS. 1 site can only have 1 arc but each arc can have many sites.

My Issue:
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...
Brian. 

Outcomes