Fileshaker

Thanks for your responses. I think that I will go the self-join / relational route to maintain live data.

Thanks once again Vaughan. I don't think that a summary field will work, because there are multiple sorting criteria that would go into the field. More specifically, I am trying to keep a running sum of a field, should the underlying record have a qualifying content in three other fields. Should one of these three fields be different.... A B C D 1 1 2 10 1 1 3 13 1 2 2 5 2 1 3 9 2 2 1 14 2 1 3 10 Trying to summarize data in column D for each unique data in column A, if data in column B = 1, and for each unique data in column C: A C Summary 1 2 10 1 3 13 2 3 19 I have the sorting mechanism for columns A & C, but Summary is non-exclusive, so I get: A C Summary 1 2 61 1 3 61 2 3 61 (Sum of all of column D, since the 1 record meets the criteria. E.g. it simply sums everything if the first record qualifies) Is there anything more specific I can do?

Hello, I am trying to query through a table record by record to add up a certain field of the records that qualify under the if statement: If ( qualification1 and qualification2 and qualification3; Sum ( add up certain field of all the records that made it through the if statement ) ; 0 ) However, the if statement goes through the first record only and, if it qualified, adds up all of the table's entries, regardless of whether they qualified individually. Is there a foreach statement or something similar I can use? Thanks.

Problem solved -> Field storing Get ( AccountName ), which of course is the relevant one, was set to store data, among other "smaller" glitches.

Problem solved -> Field storing Get ( AccountName ), which of course is the relevant one, was set to store data, among other "smaller" glitches.

Problem solved -> Field storing Get ( AccountName ), which of course is the relevant one, was set to store data, among other "smaller" glitches.

Premise: I am using FileMaker Pro 7 to create, manage, and publish a database of records that are ultimately intended for a website being hosted (purchased service) under FileMaker Server 7 Advanced. This website is ought to provide a secure user login, after which each user is supposed to view his/her records only. Problem: Since I am creating this database on FileMaker Pro 7, I have to intend it so far for Instant Web Publishing, which will be unnecessary, once it is hosted under FileMaker Server 7 Advanced. This means that I cannot yet alter any browser appearance (e.g.browser tags) other than through FileMaker's own layouts. This also means, that to test my DB online access through Instant Web Publishing so far, I am required to leave FileMaker Pro 7 open while accessing localhost:591 through my browser. Leaving FileMaker Pro 7 open has the unfortunate effect of setting the AccountName and UserName globals to the name of the user who is signed in through FileMaker Pro 7 directly. This means that though a different user logs onto the DB through the web, using IWP, this user will still only be recognized as whoever keeps the DB open through FileMaker Pro 7 directly. I hope that whoever understands my problem, or has/had a similar problem responds to my posting, because it has been a quite frustrating experience to get this to work, which might prompt me in the end to completely abandon the seemingly much more elegant and user friendly FileMaker for a mysql/php solution. Thanks in advance.

Premise: I am using FileMaker Pro 7 to create, manage, and publish a database of records that are ultimately intended for a website being hosted (purchased service) under FileMaker Server 7 Advanced. This website is ought to provide a secure user login, after which each user is supposed to view his/her records only. Problem: Since I am creating this database on FileMaker Pro 7, I have to intend it so far for Instant Web Publishing, which will be unnecessary, once it is hosted under FileMaker Server 7 Advanced. This means that I cannot yet alter any browser appearance (e.g.browser tags) other than through FileMaker's own layouts. This also means, that to test my DB online access through Instant Web Publishing so far, I am required to leave FileMaker Pro 7 open while accessing localhost:591 through my browser. Leaving FileMaker Pro 7 open has the unfortunate effect of setting the AccountName and UserName globals to the name of the user who is signed in through FileMaker Pro 7 directly. This means that though a different user logs onto the DB through the web, using IWP, this user will still only be recognized as whoever keeps the DB open through FileMaker Pro 7 directly. I hope that whoever understands my problem, or has/had a similar problem responds to my posting, because it has been a quite frustrating experience to get this to work, which might prompt me in the end to completely abandon the seemingly much more elegant and user friendly FileMaker for a mysql/php solution. Thanks in advance.

Premise: I am using FileMaker Pro 7 to create, manage, and publish a database of records that are ultimately intended for a website being hosted (purchased service) under FileMaker Server 7 Advanced. This website is ought to provide a secure user login, after which each user is supposed to view his/her records only. Problem: Since I am creating this database on FileMaker Pro 7, I have to intend it so far for Instant Web Publishing, which will be unnecessary, once it is hosted under FileMaker Server 7 Advanced. This means that I cannot yet alter any browser appearance (e.g.browser tags) other than through FileMaker's own layouts. This also means, that to test my DB online access through Instant Web Publishing so far, I am required to leave FileMaker Pro 7 open while accessing localhost:591 through my browser. Leaving FileMaker Pro 7 open has the unfortunate effect of setting the AccountName and UserName globals to the name of the user who is signed in through FileMaker Pro 7 directly. This means that though a different user logs onto the DB through the web, using IWP, this user will still only be recognized as whoever keeps the DB open through FileMaker Pro 7 directly. I hope that whoever understands my problem, or has/had a similar problem responds to my posting, because it has been a quite frustrating experience to get this to work, which might prompt me in the end to completely abandon the seemingly much more elegant and user friendly FileMaker for a mysql/php solution. Thanks in advance.

Darren, Thank you very much! This completely solved my problem, for I previsouly assigned more than the crucial ID-ID self-join relationship.

Thanks Vaughan! I created a self-join before, but noticed that it still displays only one record in the first row, and not all records across the specified range. Any way around that? H

Okay, I tried everything and still couldn't find a satisfactory way to fix my problem. I attached a screenshot of my user interface (read only form-view intended for instant web publishing) with the empty fields indicating that I would like to display all of the records from the database for that user. I cannot use a portal, since I am looking for records in only one table. Help is greatly appreciated. I already spent way too much time on this seemingly silly problem .

Thanks for your reply! I actually did not use a portal yet, because when trying, the portal does not highlight the table I need to pull the records from (or any table, actually). I also think that a portal would actually only help me to display records from related tables. However, I just need multiple records from the same table that have the same control number to be displayed row by row (same way a portal displays records). Therefore, I merely dragged in fields in hopes that it would realize that I do not want to display the same record twice, but rather two different records from the same table. In plainest English, my problem is that I want to display all of the records of one table (should the records belong to the signed in user, but that's my 2nd problem) in one layout, which is a form. I just want to display all of the signed-in user's records in multiple rows.

Thanks to transpower I made progress on my FMP 7 project. However, there are two new problems I ran into and cannot yet solve satisfactory: 1) How can I display multiple records from table rows in layout rows? - I previously assumed that adding a portal would do the trick, but for some reason I cannot highlight the table to use for the record input in the portal menu. When creating fields, it merely displays the same record over and over again in the different rows. 2) This is a standard one, but with a more specific question than the postings I saw in this forum: When restricting logged in IWP users to see their records only (which have conveniently been marked with their log in name ), where do I script the if (get(username) = field, etc.)? - I assume that I have to script it in the access privilege menu, right. Also, can someone please write out the exact if (get(username)... statement, for I am not sure what to write in case 1 and case 2. Thank you so much for your previous help! This forum has done a lot to make me feel more comfortable with FMP already and I hope to further my understanding during the completion of this project. I am quite familiar with the mysql and php synergie, and have the feeling that once I am on the same level with FMP, I will not go back . THANK YOU!!

Thanks for the reply! Is there any way to change the layout of IWP (by introducing Fireworks or InDesign created buttons, etc.) on Mac X 10.3 as well? It is my understanding that Lasso in connection with FMPSA eases web publishing by offering a userfriendlier CMS environment and offers much more design customizability. Is this correct, and, if so, would it be worth trying to get a copy in order to webpublish the medium sized DB I mentioned in my initial posting? Thanks again! -H