Showing records orderred by Role

[Frank Situmorang]

Hello experts:

I tried to make my church membership database more or less like the address
sample of MS Access. I modified some and it works.

My question is on the members form in the 2nd tab, I want the presentation
of the member of the family is ORDERED by role ( I have the table of role
sequence by role):
Father, Mother, 1st son, 2nd dauthter....which is in Indoensian of course.
How can I make it sequenced by role.

Thanks in advance

 

[Maurice]

Hi Frank,

If your form is based on a query you can set the order option in the query.
Go to the querygrid and look for the field Role -> set the orderoption in the
querygrid.

hth

 

[Frank Situmorang]

The problem Maurice that I do not make any link with this Role table. Member
form is the subform of the Household/Family Form which contains General
information/address. I have the field in the member form using combobox to
select the role.

So what I have is form of Housefhold form on which there is a tabcontol, the
fisrt tab is General information and the 2nd tab is members, where we can see
all members of the family.

Thanks for your more explanation/helps