Glasstream

I figured it out, it seems Filemaker wants the straight number 10000 instead of entering 10,000.00. It shows the same in the database, but when carried over to the web page it doesn't.

I am pulling data out of FileMaker 10 server to a web page and displaying numbers in a table, everything works great! until a number goes over 9,999.00 then it just doesn't display at all. Anyone have any idea what is causing this and how to fix it? I assume it would lay in my php code since the number 11,000.00 is showing in the database, just not in my table on the web page. My code: <?php echo '$'.number_format(round($Number_row->getField('iAverage'),2),2); ?> Any help would be much appreciated!

Sorry, I wrote it down in the post incorrectly, I do have double colons between mine, but still nothing is showing up in the total.

Ok, hope this is an easy question. I have a table called BBP and a table called AW and a table called RS and also MR. All the tables have records on them and I have created a field called records that uses a calculation Get (TotalRecordCount) and it displays the total number of records and updates when more are added. I then created another table called Title, with a relationship to all the others and put the records field from each of the other tables onto this table. So I have all the totals from each of my tables showing up on the title table and I try to create a calculation field to add up the 4 related fields (like - Sum (BBP::records; AW::records; RS::records) etc.. but does not work for some reason. I am new and just figure I am missing something easy. Any thoughts? Thanks in advanced.

Ok, sorry if I'm not getting this right off. Populate the IDs in the join table, by indexing them? or what didn't I do? Also, is there a way that I can average the fields in the portal? like at the bottom of the portal or below it, to show the average of Entry, then next to it show the average of days? By the way, thank you so much for your help!

Ok, I have tried to make a file from scratch to try and replicate the join-table example. Could you by chance point out what I have did wrong in my relationships? I did schools in place of companies, but it shouldn't matter what the name is. Posting the file. Thanks very much! test portal.zip

So when all 3 companies enter there data online and it drops it into FM, into the CompanyPositions table, how would I sort which company the info was from? would it be tied from the Companies table? What would the relationships look like? Thanks so much, as a novice I still trying to wrap my head around FM and relationships.

Thanks for the replies! The entry, days, amount would be like Title=Director, Entry=22,000, Amount=26,000 - basically a listing of what these positions basic pay scale,days worked etc... The 3 companies would not have access to the other tables because I am basically pulling the info to the web from FileMaker via php. Not a php programmer either, so was wanting the info on a layout that I could easily tie to. What I am struggling with is on all 3 company tables I will have like 63 different positions which are identical between the 3 tables. I want to take the director position from all 3 tables and show the difference and add fields to calculate averages between the 3, so one might have Entry=22,000 and another company might have Entry=34,000 etc... So I am trying to setup a portal and for the life of me it is not pulling the records no matter how i do the relationship. Have a Primary key and foreign key with the primary key auto enter serial and the foreign key using a look-up. Am I missing something easy here that I do not see? Hope I am explaining this correctly, Thanks again for the replies and help!!

What would the relationships look like? Also, how could you add new fields to say, average the 3 records from the 3 companies in a portal? The companies could only view their table and nothing else. Thank you very much for the reply!

I have question and it could be pretty easy but as a novice I am struggling with putting it all together. Scenario: I have 3 companies that each have a listing of positions. example: Director, manager, technician, trainer etc.. and the positions are identical for the 3 companies. So I have made a table for each company and the fields are the titles of the positions with info like: entry, days, amount etc.... They are also only able to access the table that is for their company. A person from each company will enter in the data for each position and update it once a year if anything changes. I want another table to have the director position listed on it from all 3 companies, and another with the manager from all 3 etc.. So it maybe could be used as a comparison by a 4th party or whatever and even have some calculations like averaging the amount of all 3 Director positions etc... That the companies would not have access to. I have the 3 tables for the companies but I am struggling to pull the single fields from each of the 3 to the 1 table. Not sure if I am going about this all wrong, but was thinking of adding a field that could hold a number like 1 for director, 2 for manager etc.. and use that number to pull the records into the table and if that is something that work, how would I go about setting that up? If I have left out any information please do ask! Again I am still learning FM and am very thankful in advance to any response! Using FileMaker 10 advanced

I have looked and found nothing that has worked, seem that most solutions are more complicated than I need. I have to tables - table 1 and table 2 I have a drop down in table 1 with a vlaue list, I want to be able to select a name from that drop down and click a button that preforms a script that will take that name(dropdown field) and create a new record on table 2 with a timestamp. I know this is probably super easy, but I missing something to make it work. Guess that how we all started i hope Thanks in advance!

Thanks a bunch, never would have thought of searching for Dwindling Value Lists Awesome, again thank you!

Have looked around but not seen anything that seem to cover this. Question I have is: I want a value list that has a bunch of titles that a user can pick to enter in info on that title, but I want that title to disappear from that value list if it has already been chosen. So only that titles that have not been chosen show up in the value list till they are all gone. Is this possible? Thanks in advance!!

Wow LaRetta, thank you very much! while looking at your solution that works, trying to figure out how it works, it looks so simple. This I need to learn more about, so hitting the books and web again. Again thanks so much for your time, and your example! You are awesome!

Thanks, I got to fooling around trying different things and it got a bit, well you know.. hopefully this one is easier to read. I have been looking around the forum and did a new layout from what I have seen in other posts. I have the first filed called Task, value dropdown. A second called item, which is populated by whatever is selected in Task. Then the 3rd is Action, which I would like to populate with the corresponding number like (1.1.B.1.1) or whatever is in the column of the one selected. Right now if I select Evaluation & Assessment, and I select one in the item field it shows all the numbers that are listed that have Evaluation & Assesment. I would like it to auto populate the number that corresponds to what is selected in the field (Item), but not allowing it to be edited. I am very thankful for your time LaRetta and anyone else that might have some input. Thank You very much! Test.zip

Thanks so much for your time LaRetta! I have uploaded the file. user is admin password is blank Thank You again! Logs.zip

Sorry,I probably didn't put enough information in my first post. My first field is a dropdown to select a catagory ex. Instruction. When it is selected it populates everything in the next field on the table that has the catagories with the field on that table ex. FileMaker Tutorials. I have another field in that table that has numbers like 1.1.A.1.1 that are different for every entry, so the table would look like Instruction FileMaker Tutorials 1.1.A.1.1 Assessment Schools 1.1.B.1.1 etc.. So wanting the 3rd field to auto populate denpending on what was selected in the second field. Plus be non-editable. I have tried the same settings as the first field but either I am missing something or it has to be done in a different way maybe? Thanks so much for the reply, hope it not something easy that I am missing :P

I have a beginner question and have not seen an obvious solution on the forum, so if I missed it somewhere, please point me in the right direction. I have a 3 fields. First one you choose a subject, the second one populates the information that goes under that subject. Works great, but wanting another field to autopopulate a number based on the selection of the second field after it is chosen. I'm sure it is probably easy, thanks for any advice.