I want to show "1 student" , "2 Professor " in same field.
In same field of what record?
How can you tell that these two records should be compared? (Professor teaches and student attends same class perhaps?)
There are several approaches that can be used to compare values between records, the simplest is to just sort the records. But the best method requires that we know more about what you are trying to do here.
"sort" is not enough beause "sort" just show the results.
I want to show or write the result in a field, like Field_C.
in case of writing article, author's order is very important.
for example, 1st author is moon-young lee, dds, ph.D student, 2nd author is sang-won lee, professor.
I want to show the result form like " 1(superscript) moon-young, dds, ph.D student, 2(superscript) sang-won lee, professor " automatically.
thus i must compare "1" and "2" in same field at different record.
Student, professor is in same institute and write article with co-working.
My point here is that in order to know which records to "compare", some rules have to be established in order to identify which records should be compared in this way. The rule appears to be that they both are authors of the same article--though how you specify the order in which they are to be listed is not readily apparent.
Say you have these three tables:
Authors----<Author_Article>---Articles (---< means one to many, many authors could write many articles. )
Author_Article functions as a join table to support the many to many relationship implicit in your description of this issue. If you define a number field, Order, in Author_Article, to determine which contributor is listed first, you could define a calculation field, cOrderedAuthor that returns text which looks like this: Order & " " & Authors::AuthorName.
If you specify a sort order for the relationship between Articles and Author_Article, this calculation in Articles would produce your sorted list of authors: Subsitute ( List ( Author_Article::cOrderedAuthor ) ; ¶ ; ", " ).
Final note: to get your superscript, you can use the TextStyleAdd function in cOrderedAuthor to specify a superscript style for the order value.
i will try..
thank you agian..