1 Reply Latest reply on Mar 31, 2011 11:57 AM by philmodjunk

    Lists

    MartinFreidman

      Title

      Lists

      Post

      I have an art collection and am seeking insurance valuations for each object. Upon receiving valuations from various dealers I need enter the information. Each needs to have its own card. I need to be able to access each card as well as a list of all cards. Each card needs to have. I need help finding and creating a file  that list items eg. collection of paintings that would provide Titles, Mediums. Size, Date, Insurance value. Option to provide lists that use different forums that most importantly calculate valuation totals. I have used this system successfully with FileMakerPro 6. 

        • 1. Re: Lists
          philmodjunk

          FileMaker doesn't have "cards" so I will substitute "records" where you have put "cards".

          Will the same object be evaluated by more than one dealer and you need to list them all?

          If so, you need two tables:

          Objects::ObjectID = Valuations::ObjectID

          You can place a portal to Valuations on your objects layout to enter and list all the valuations for this object.

          I'm not sure which valuation total you want here, the insurance value set for each object or some kind of total from the related list of individual valuations.

          To compute a total insurance value, you can define a summary field in Objects that totals the insurance value field.

          The method I have described works with FileMaker 6 and also with newer versions, though the steps you follow in setting this up will differ slightly due to FileMaker 6 being limited to one file for each table where later version aren't and due to the fact that recent versions have a different method for defining the relationships.