Auto Create Records in Related Table

Discussion created by alas on May 28, 2012
Latest reply on May 28, 2012 by alas

I am having an issue that is driving me crazy. Because I imagine there is a simple solution but I can't seem to figure it out. I have two tables that are related on the unique ID field (Call them Table A and Table B). Table B contains three fields that are calculated fields based on a field in Table A. For all intents and purposes, I could have just put those three fields on Table A. But I wanted to keep them separated because I may ditch them later and wanted to keep them "off ot the side".


So in Table A, there are 910 records. But in table B, I have no records. Ultimately there shoudl be 910 of them.


I know if I have a related field if I put the field from Table B onto a layout with Table A info, when I fill in that field from Table B (call it Calc1), it would automatically create a new record in Table B, tied to the ID from the record in Table A. (I have the allow record creation checkbox in the relationship definition).


What I can't figure out is where Calc1 is a calculation, that record creation is not automatically done. I can only get it to work by going into Table B, filling in the ID field with an ID and then the calculations are performed with the relationship in place.


How can I get FM to automatically create records in Table B, based on a record/ID existing in Table A?