Newbies naomi87 Posted February 27, 2005 Newbies Share Posted February 27, 2005 ok so here's what I have...i want to create two separate portals (cheques and invoices) to be displayed on one layout (profit overview). I had to create an aliased table for the relationship to work so that invoices and cheques are sorted out by month via a value list. however, the portal linked to the original table works, but the portal linked to the aliased table doesn't. I am so stuck, and a newbie - please be kind if i'm simply being thick! Link to comment Share on other sites More sharing options...
Vaughan Posted February 28, 2005 Share Posted February 28, 2005 An aliased table! What's that? Link to comment Share on other sites More sharing options...
Newbies naomi87 Posted February 28, 2005 Author Newbies Share Posted February 28, 2005 It's where FMP7 won't let you create two relationships to the same table so you have to create a copy, but the copy doesn't show up as a layout or a separate table, it is seen as a mirror. i think... Link to comment Share on other sites More sharing options...
Bagel Posted February 28, 2005 Share Posted February 28, 2005 Maybe you could give us a bit more information about the structure of your database. How many tables are we talking about - one, two or three - and how are they related? The term FileMaker uses for what you are calling a "aliased table" is a "table occurance." Link to comment Share on other sites More sharing options...
bikergeek Posted February 28, 2005 Share Posted February 28, 2005 This table/relationship stuff can get pretty confusing for a beginner. You have to make sure that the matching fields in the relationship actually match, according to the operator used in the relationship definition. The fields have to have their upper-left corners within the area of the portal to be considered protal fields, and only the part of any field that lies within the portal area will be visible at all. The field in a portal do not have to be from the table or occurrence that the portal references, but which occurrence they're from will determine which records actually match and are shown. Make sure that the fields are from the table/occurrence you want. Link to comment Share on other sites More sharing options...
Newbies naomi87 Posted February 28, 2005 Author Newbies Share Posted February 28, 2005 ok thanks guys! have changed data structure - didnt make sense - and am now sorted! thank you Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6997 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