Showing records orderred by Role

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

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
 
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
 
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
 
Back
Top