I'm having trouble entering a new related record in a portal in a new database I have created. I cannot tab to it, or even click on it. I just created a database to consolidate several others that I have used for years. One set is a typical Invoices/Addresses/Products/Lineitems four table database which is working fine. I have exported the Products and LineItems tables to try to create this integrating database. I am now creating a table which records the payments, called Checks. It references the LineItems with CheckNum, so if CheckNum 3401 paid for 2 widgets and 4 gadgets, they show up in a portal in Checks and I get six items for a total of $XX. I put a portal in the Checks layout, and it references the LineItems ok, but it will not allow me add new records. I should be able to create check #3402 and create quantities of widgets and gadgets all from this one layout.

Another poster here indicated that he could not tab to a new record in the portal, but he could click in a new row and make a new record. Resetting the tab order seemed to fix his problem. I cannot even click in the portal to add a new record. Tabbing simply takes me to the first field on the layout, outside of the portal. Clicking doesn't allow me to find an empty field to type into.

In my original four table Invoice DB, the minute I tab to a row in the portal, I can see a row below in dotted lines which would hold the next record in the portal, should I choose to add one. However, in this database, I cannot see that empty row at all.

Please help. I have been using FMP since version 3 came out, and have been using databases since 1983, and I even have a variety of simple scripts... but I am more of a user than a programmer, I guess.

--Stumped

Hi rcarbaugh,

Go into your relationship graph and find the relationship which has the portal attached. Click the = between the relationships to bring up your relationship dialog. At the bottom, check 'Allow Creation of Related' on your Portal side. I believe that might fix you up but if not, post back and we'll explore further.

LaRetta

Thank you, thank you, thank you! That solved it completely. Dunno why it wasn't in the help file under portal. It's probably in the table/relationship area.

I had hoped that it was simple like that.

Thanks.

Rod