AnsweredAssumed Answered

portal records disappear

Question asked by eibcga on Jun 28, 2010
Latest reply on Jun 29, 2010 by eibcga

Title

portal records disappear

Post

I have the following tables and relationships (irrelevant fields are not mentioned to save time):

 

NAMES

pk_name_id link to JOURNAL::fk_name_id

name

 

JOURNAL

pk_trans_id link to LEDGER::fk_trans_id

fk_name_id link to NAMES::pk_name_id

date

memo

 

LEDGER

pk_trans_lineitem

fk_acct_id link to ACCOUNTS::pk_acct_id

fk_trans_id link to JOURNAL::pk_trans_id

cleared

amount

total

balance

 

ACCOUNTS

pk_acct_id link to LEDGER::fk_acct_id

acct_name

acct_type

 

Link to ERD: http://www.4shared.com/photo/IzOlqfzp/Screen_shot_2010-06-29.html?

 

I have 'Allow creation of records in this table via this relationship' for both the LEDGER and JOURNAL table.  Primary keys of all tables are auto-enter serials on commit (not on creation).

 

In Form View in the JOURNAL table of transactions, I have a portal to show related records from the child table, LEDGER of transaction line items.  When I click the Go To Next Records arrows in the toolbar, the records of transactions and related records of transaction line items in the portal show as they should.  The problem starts when I create new records in the portal.

 

I add a new transaction record by adding a new record in the JOURNAL table in Form View, and fill in the necessary fields.  I then go into the first line of the portal to create new related records of transaction items and fill in the necessary fields.

 

After I have finished entering all fields and records in the portal for the transaction (usually no more than two records of transaction line items for any given transaction) in the portal and click outside the field to commit the related records in the portal, the new related records I created in the portal disappear and the portal is blank (which previously showed two new records BEFORE I committed them).  Why did they disappear?

 

I believe the new records that were in the portal AFTER I committed them are disappearing because the transaction line items did not save the related transaction ID number.  Without this transaction number, the 'related' records in the portal after creating them do not know which Transaction they are related to and thus, disappear.

 

When I look in Table View of each of the JOURNAL and LEDGER tables, I see the new transaction and transaction line item records I created when I was in Form View as mentioned above.  The new JOURNAL record shows the new Transaction ID and the fields I filled in earlier (while in Form View).  The new LEDGER records show the new Transaction Line Item ID and other fields I filled in earlier while in Form View, but the JOURNAL::pk_trans_id related field in the LEDGER table shows as blank.  This is consistent with what I saw in Form View.

 

I can't figure out why the new LEDGER records of transaction line items will not save the related Transaction ID.

 

Any ideas?  I hope I painted a good enough picture.

 

Thanks. 

A beginner in FMP11 on Mac OS 10.6.4.

 

Outcomes