Results 1 to 4 of 4

Thread: file maker to display the contents of last record

  1. #1
    Join Date
    Aug 2006
    Posts
    222

    file maker to display the contents of last record

    Hello all,

    I am using using FMP 9 on a MacBook Duo, OS 10.5.8 .I have a table that has multiple entries for a given Identity.I notice One of the items is an status field that displays one out of two states new and experienced.I am with a layout that has this field, and it only displays the first record's status field How would I get it to show the one from the most recent record?

    any thoughts?

  2. #2
    Join Date
    Apr 2008
    Posts
    2,139

    Re: file maker to display the contents of last record

    It depends a little on how your tables are related to each other and what it is you want to show up. The basic solution is you can't have sub portals. But you can display content on a one to one basis.What you are describing is very do-able and very easy.I will work up a little demo and send it over to you.If you define a calculation field in the Parent table as Count ( Child::Matchfield ), it will display the number of children of each parent, and it will do so across all records in the Parent table.

  3. #3
    Join Date
    Sep 2005
    Posts
    1,306

    Re: file maker to display the contents of last record

    Actually the table contains a field that shows in multiple records - it's contents are either "New" or "Experienced". A person is always new when first entered, and they may stay in "New" status un continuously, or at some stage be altered to "Experienced"; once in this category, the person is always treat experienced. But, if I put that field on a another layout, it only will give the value in the first record in which that person appeared, so even if the second or later record tells "Experienced" the field is from the first record for that person, which means it always shows "New".

  4. #4
    Join Date
    May 2008
    Posts
    4,570

    Re: file maker to display the contents of last record

    For any given data entry field "TextFont", make a corresponding calc field of this kind (type=text definitely ), and overlay it on the data entry field, with field entry set to OFF in both Browse and Find modes and storage set to do not store and Place a date in the Experience table and sort by descending date in the Experience portal (placed on the Person/Employee layout).

Similar Threads

  1. Regular Expressions on the Contents of a File
    By samualres in forum Software Development
    Replies: 4
    Last Post: 19-02-2010, 10:30 PM
  2. Windows 7 search does not return file contents
    By Benedict in forum Operating Systems
    Replies: 3
    Last Post: 05-12-2009, 10:38 AM
  3. Replies: 3
    Last Post: 23-07-2009, 09:31 PM
  4. How to import txt file contents into lists in python
    By Jasonholt in forum Software Development
    Replies: 3
    Last Post: 16-05-2009, 06:23 PM
  5. Display Contents of XML File
    By fastrod in forum Software Development
    Replies: 3
    Last Post: 14-03-2009, 12:52 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,751,815,205.22342 seconds with 16 queries