AnsweredAssumed Answered

sorting pulled fields from external db file

Question asked by jared67 on Sep 12, 2010
Latest reply on Sep 13, 2010 by philmodjunk

Title

sorting pulled fields from external db file

Post

I have:

file1:projects.table

file2:categories.table

I'm using the remote "categories" rows inside of the main "projects" database. I can successfully see a checkbox group made up of categories on every projects records.

I also have a "ratings" field on every category entry. I'd like to be able to sort the imported category like:

outside jobs : 1

inside jobs: 3

wife: 5

etc...

So far, filemaker is only sorting alphanumerically. I've set Define Database>Relationships>[clicked on the equal sign between two tables]>Edit Relationship>Sort Records: Sort on Priority field. This does not work.

I'd rather not hardcode 01,02,03 into the categories, because I'd like the calculation ability later down the pipe.

Outcomes