Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6131 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I have a database in Filemaker 8.5 that tracks Accounts in the main table, transactions in another table, and the account number is the field on which they are joined. Each Account has anywhere from 0 to 200 transactions.

My problem is that some Accounts seem to have 'phantom' transaction records showing up in the portal. The portal is on an Account layout, and the transactions are sorted so that the newest transaction is to be at the top. When I try deleting the bland transaction record, the record count for transactions within the account is decremented, but the overall count of transactions is not decremented.

Other facts about the database - there are other tables, which are joined to the Account table by the account number or by other fields. And there are lookup fields in the Account table based on some cumulative values in the Transaction table.

I expect I have done something incredibly stupid, but time has gone by and I'm not finding the cause of my problem.

Any suggestions?

Posted

Not sure I follow completely but by chance do you allow records be be created via the Relationship? this will show what appears to be a blank record in a portal.

  • Newbies
Posted

Thanks for your reply. I do allow the creation of records, as you state. And each account shows an empty last row in the portal for that. But about 40 accounts have additional empty rows, which sort up to the first rows of the portal. I'm sure I'm missing something obvious, but I sure don't know what it is.

This topic is 6131 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.