Jokez Posted September 14, 2005 Posted September 14, 2005 Hello! I have a samll test database were I have a table Person and and a table Jobb since a person can have many jobbs I have a Person_jobb table. In that Person_jobb table I have a field that I want to show in a portal for every person. But it only takes the first value and show it on all persons in the portal See the example!! How can I make it so that it shows the stored data in the middle table for each row in a portal??? (Not just the first posts value an all rows) Many many thanxs too u that helps me!! // Jocke TEST.fp7.zip
SlimJim Posted September 14, 2005 Posted September 14, 2005 The portal is pointing at the wrong table occurrence. If you want the field value from the join table to show then you have to set up the portal to point to that table: Person_jobb. The person data in the far jobb table will still show correctly in a person_jobb table.
Jokez Posted September 14, 2005 Author Posted September 14, 2005 Yepp that made it work, but let say that I just wants to show all jobs at just one company in a portal aswell? Make some kind of filter? // Jocke
SlimJim Posted September 14, 2005 Posted September 14, 2005 Yes I'm sure that is possible. But there is no company data in your attachment so it is difficult to advise you as to how to do it.
Recommended Posts
This topic is 7011 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