Hack Posted February 23, 2006 Posted February 23, 2006 (edited) Hi, I must be doing some thing wrong with my Portal and relationship tables as I not getting data showing on my portals does any one have any tip attached are some screen dumps regards Hacky ;) Edited February 23, 2006 by Guest
Lee Smith Posted February 23, 2006 Posted February 23, 2006 I'm getting an error trying to zoom in on your attachments. So I can't see the field names, and relationships. Why not post a copy of your file so we can see it? Lee
Hack Posted February 23, 2006 Author Posted February 23, 2006 (edited) Hi Lee I have upload another couple screen dump of the relationships see what you think???, (not to keen to up load the FM file as it has client info on it but... may be I can get around it by creating an new data base and striping out some of the data... i will do this if we need to.....) thanks for time Cheers Hacky ;) Edited February 23, 2006 by Guest
Inky Phil Posted February 23, 2006 Posted February 23, 2006 Hacky If it helps you can save as a clone which will save the file structure but with no data. Phil
Hack Posted February 23, 2006 Author Posted February 23, 2006 Hay thanks phil I have just attached an clone of the FMP file I am having trouble with the portal not pulling data through Cheers Hacky print_specs_Clone.fp7.zip
Inky Phil Posted February 23, 2006 Posted February 23, 2006 Hi Hacky I just had a sneeky-peek at your file. I assume that it is the portal at the bottom of the client layout that you are having difficulty with. I cannot quite work out what you are trying to do but the first thing to change is that the fields you have placed into that portal are fields from the project sheet relationship and the portal is formatted to show fields from the print specs relationship HTH Phil
Lee Smith Posted February 23, 2006 Posted February 23, 2006 Hi hacky, I looked at your file It might have been helpful for you to include some of the records that would have then made it easier to follow up with questions. I entered a basic project and client, can you tell me what it isn't doing? Lee
Hack Posted February 23, 2006 Author Posted February 23, 2006 Hi Phil and Lee I have just add new clone with some data, The Portals is in the client layout area I was wanting to bring up a table of all projects having >company< >job ref< >job tile< and also having them as the relationship data links accross the tables ....... if this correct thanks for time again Cheers Hacky print_specs_Clone.fp7.zip
Lee Smith Posted February 23, 2006 Posted February 23, 2006 Okay, I review the latest file. First of all, do not base a relationship on a company name. They can change, be entered wrong, etc., it is better to use a unique ID. First Create a Client ID field in the Project TO, Next, populate the Client_Id (I changed your ID field to this in Client) with a unique number for each client. And be sure to use the same number Project TO Next, create a Relationship from the Client TO to the Project TO based on this new Field Next, change the Portal from whatever it was to this new Relationship. Next, choose each filed and change them to the New Relationship too. Here is your file, Modified as I explained above. HTH Lee print_specs_Clone-1.fp7.zip
Hack Posted February 23, 2006 Author Posted February 23, 2006 Fantastic the portal it working thank very much Lee Cheers Hacky
Recommended Posts
This topic is 6865 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