Web Publishing and Portals in FMP7

November 6, 2008 11:37 AM

I'm working in Filemaker Pro 7. I've created a basic database for tracking computer system hardware. Most of it is in one main d/b, with some related tables for passwords, user ID's, updates and the like. My problem is that when I publish the main d/b using instant web publishing, the fields from related tables do not show up. The portal is there but there's no fields in them. What am I doing wrong?

For example, I've got a main database which is a list of computers, each record with a unique ID #. I created a new table for passwords and each record in it has a unique key #. I relate the computer list ID # to the password table unique key # and am now able to create a portal on the computer list d/b and show records from the password table. That all works swimmingly.
When I then publish the main table using web publishing, I can see all the fields and information in a browser except anything in a portal coming from a related table like the passwords. The portal is there but no records are visible inside of it.
Is there something I'm doing wrong, or is this not possible?

posted by diode to computers & internet (3 comments total)

This should absolutely work -- this is basic, vanilla, Instant Web Publishing (IWP) behavior. Displaying related data in a portal is absolutely supported.

Are all of the tables in the same file or separate files? If separate, I'd make sure the related tables are set to be shared.

Otherwise, you'll need to give some more details, or maybe post a clone of the file so we can take a look at it. In general and apart from a few script steps, if it works in desktop mode it should work in IWP.
posted by mosk at 1:47 PM on November 6, 2008

Oh, and one other thought: are the access privileges wide open at this point, or have you configured them for any of these tables? Because it's definitely possible for access privileges to prevent related data from displaying. On the other hand, if access privileges are still vanilla, this shouldn't be an issue.
posted by mosk at 2:37 PM on November 6, 2008

Yes, you were right. The problem was access privileges.
posted by diode at 10:04 PM on February 23