List results in my order, not autonumbering etc.

K

KathleenF

I set up database where for each matter there are several of people involved.
I need to be able to list those people in the order I specify, such as
first, second, third, or like president, vice president, secretary, etc.
There are many matters, each with lists of people.
How can I set this up and create a query to obtain wanted results?
 
K

KathleenF

Thanks. I don't know if you can explain this to me in words. I have an
invention table with a unique App number for each. There are six inventors.
I have an Inventor table. Of course, the inventors want their names listed
in order of importance, biggest guy first. So one would be Inv1, next Inv2,
etc. There are many inventions and many inventors. How do you link them?
Or query them?
 
Top