Clarion - Ordering a browse window using fields from multiple tables

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Ordering a browse window using fields from multiple tables

2004-05-13, 7:30 am

Hi

A quick question re the above

If I have 2 files A and B where field a1 has a many to one
relationship to field b1, as follows:

a1 = authorid
a2 = book title

b1 = authorid
b2 = authorname

I then have a browse displaying the fields a2 amd b2 ie book title and
authorname

what is the best way to get a browse to display all records in file A,
sorted by authorname, book title ie b2, a2?

thanks
Ed

Sponsored Links