Commit Records in Portals?

[akasha]

I have created database for 2nd mortgages and have 3 main tables:

Borrowers

Investors

Mortgages

I have managed to get working to point of calculating the mortgage payments, etc. (amortization schedule) which creates "on the fly" up to 300 new records (via scripting) for each borrower. This script relies on showing all records and then deleting them before it creates a new amortization schedule. This is how I think i want it as it would get very big very fast for a lot of mortgages. The problem I am having is getting these "records" to transfer to a portal so that I can commit them to the Borrower record. I can show these records in a portal via a 2nd TO, but I can't seem to figure out why I can't commit them to the borrower record when all the relations seem to be working.

I'm pulling my hair out...there's not much left...can someone help?!!

[Rob 7 Collins]

pardon me but, this is a very ambiguous description, so the help I can offer is limited.

Do you mean that you have these records you've generated, who's fields match the fields of the Borrowers' table, but are instead in some other table -- ie, that you want to move the records to the Borrowers table itself? If so, you could import them via script.

If your desire to "commit them" is different, tell us more. someone's bound to have an answer.