Portal not behaving (as I think it should)

[BergsHM]

Hi! I am new to Filemaker, but have done several hours of tutorials and was pretty confident when I started to build a little portal yesterday. Essentially, my portal needs to act as a portal on an Invoice layout, where the user can add a certain quanity of specified products to a invoice list, which is then summed at the bottom.

 

My first try did not work, but I found a fantastic little example Filemaker Pro file that seemed to work perfectly (admittedly, it was Filemaker 7), but its portal included fields that could be edited with the number of the product, which then populated the price further along on the line, and the user was expected to enter the quantity.

 

What I need to do is exactly the same, but with materials and components. I think the relationships are the same and I have been very careful in setting them up with a join table between materials and components. But even when I COPY the portal from the example file to my own file, something gets lost and the nice little fields that can be entered data into are not visible in Browse mode (even after I change the table references to the appropriate name).

 

Would someone mind please having a look at the example portal on the Invoice layout of the attached file, and telling me what on earth I am doing wrong? I have been meticulous in checking that the settings are consistent, but I must have missed something. 

 

(Ok, now this system won´t let me upload the fmp12 file, despite the fact that it is only 246KB in size.) I will post this message and then see if I can figure out what the problem is with the upload...

[Kris M]

You cant post .fmp12 files. you have to zip them

[BergsHM]

I would love to upload these two zipped fmp12 files for you, Kris, but I seem to be a complete idiot who can´t even figure out how to upload a file on this site. What obvious thing am I missing now? 

[Lee Smith]

Hi Bergs, and welcome to the FM Forums,

 

I moved your topic from "FileMaker Pro 12" to "Portals”, because we have a Portal Topic, and the General Topics are reserved for discussion of the new tools, features and functions that were introduced with that release of FileMaker.

 

To attach a file, just follow the steps you will find here. ATTACH A FILE

 

Lee

[BergsHM]

Thank you so much for your help! Here are the two attached zip files. The Invoices Demo Filemaker file is the example one I found online that has the wonderful portal I would like to replicate in my own database (an edited version attached as "components materials copy copy").

 

The location of the new portal (that does not work) is now on the Komponent Instance layout in my database. There are lots of Norwegian titles on the database, but that should´t matter I hope...

 

If you have any ideas on how I can make the new portal editable directly in the portal, I would be EXTREMELY grateful. I have been working on this one bit of the database for over 24 hours now. And seemingly getting nowhere. Thanks in advance.

components materials Copy Copy.fmp12.zip

InvoicesDemoFilemaker.fmp12.zip

[David Jondreau]

You need to check the "Allow creation of related records..." box in the relationship on the *join* table side.

 

*And your key fields are screwy. I can't figure out why you've set it up that way, but you should be using random UUIDs (or possibly numeric serials) for keys. Not user entered text.

[BergsHM]

Thanks David. I will look at those problems. (I had actually been wondering about the IDs not being numbers...)