Wikisnoodle Posted August 8, 2011 Posted August 8, 2011 This has to be basic... I am building a db that has eight portals, so far. An example of seven of them… 2 related tables, ‘List Manager’ and ‘Staff’. Relationship based on auto-enter ‘ID’ field (=1). ‘Staff’ has 2 fields which are also in a portal in ‘List Manager’. Create a record in List View ‘Staff’ and a portal row is created in List Manager’s single record. Fill the fields in the List Manager-based portal and as you would expect, the related record is filled (and vice versa). The eighth… 2 related tables, ‘Invoices’ and ‘Invoice Forms’. Relationship based on auto-enter ‘ID’ field (=1). ‘Invoices’ has 5 fields which are also in a portal in ‘Invoice Forms’. I have created 33 records in Form View ‘Invoices’ and filled the 5 fields in each. The portal in Invoice Forms’ single record is displaying 33 blank rows. I have checked the relationship, that ID fields always contain"1", that I have the correct fields in the portal, that they are within the row, even that text is black. What else could cause portal rows to have no content? Incidentally, to print multiple pages from this portal I am also using <http://preview.tinyurl.com/3o8rmyw> which is <http://help.filemaker.com/app/answers/detail/a_id/2948/kw/multiple%20page%20layout%20print/session/L3RpbWUvMTMxMjc5ODQ2My9zaWQvd2ZPKlRfQWs%3D>. So far, the second portal shows the first record/portal row only, with text!
bcooney Posted August 8, 2011 Posted August 8, 2011 Your misuse of the FM terminology has me confused. "A db that has eight portals." What does that mean? "2 related tables, 'List Manager' and 'Staff'" Huh? A "List Manager" table? Related by a constant 1? "2 related tables, 'Invoices' and 'Invoice Forms.'" Again, huh? Could you post a sample file, bcs I believe you're off to a very bad start here.
Wikisnoodle Posted August 8, 2011 Author Posted August 8, 2011 Sorry to confuse. I had seven (now five!) working portals in the database (db), and one portal that's playing up. 'List Manager' is a layout (actually the table is called 'Main Menu' for want of a better name). One user will be able to access and modify its contents (portals) giving him control over drop down list contents (I know there are other ways to edit drop downs). "Related by a constant 1" - it works for all but one portal, and I can't think of another relationship that would do it! Wherever asked account login = admin; no password (for now!) Thanks for taking a look.
comment Posted August 8, 2011 Posted August 8, 2011 It sounds like the fields in the portal are coming from the wrong occurrence of the child table. BTW, the 'Main Menu' idea can be problematic if two users want to modify contents at the same time. Also, "Related by a constant 1" is obsolete - use the x relational operator instead.
Wikisnoodle Posted August 8, 2011 Author Posted August 8, 2011 Just as an update things aren't right yet, but the portal rows are no longer blank. I have done nothing, apart from quitting and relaunching Filemaker (for other reasons).
Wikisnoodle Posted August 9, 2011 Author Posted August 9, 2011 < the 'Main Menu' idea can be problematic if two users want to modify contents at the same time. Also, "Related by a constant 1" is obsolete - use the x relational operator instead. > Thanks for the points made. 'Main Menu' only contains two layouts - one is the initial layout with buttons to all other layouts and databases (better called 'Home'?), the other is the admin-account-only 'List Manager'. It's only called 'Main Menu' because that's what the intro layout has always been called (in the Access database being replaced). I only recently jumped from v7 to v11, so 'x relational operator' is a new concept I will have to investigate.
comment Posted August 9, 2011 Posted August 9, 2011 The x relational operator was introduced in version 7.
Wikisnoodle Posted August 9, 2011 Author Posted August 9, 2011 Just spotted we are supposed to zip uploads, so here goes again.
Recommended Posts
This topic is 4874 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 accountSign in
Already have an account? Sign in here.
Sign In Now