[RESOLVED] Newbie needs help - probably simple.

[drag0n_45]

Hello all,
This is my second Crystal Report. It took me about three weeks to get the first one to work properly, and I have absolutely no idea where to start on this one.

I wrote a program in Vb6 to store and manage all of our procedures. The procedures also contain forms (for example, a procedure could be how to use a certain program and it could have a form that is needed to request changes to that program). The procedures are stored in one table in the database, and the forms in another, linked in Crystal Reports X by a common key. Each form can contain multiple revisions, so at any given time there could be 5 or more instances of the same form, all with a different revision number. This is also true for each procedure.

I need to be able to display the procedure with the highest revision, then the information about the current procedure (seems simple enouhg,) but then I need to display all of the applicable forms for that procedure, with each form displayed being the highest revision number for that form only.

So, if I have a procedure OP-000 named Go To VBForums.com For Awesome Help, and it's the first revision dated 01/09/1987 and there's two forms associate with it: OP-000-01 named Moderator Privelage Request From, of which there are two revision: rev 0 and rev1. The other form could be OP-000-02 named Member Request Form, of whcih there may only be one revision: rev0.

I'd want that data to be displayed something like:

OP-000 Rev0 Go To VBForums.com For Awesome Help 01/09/1987

Forms:
OP-000-01 Rev1 Moderator Privelage Request Form
OP-000-00 Rev0 Member Request Form


I can handle the formatting, but notice that only the form with the highest revision number is being displayed? That's where I'm stuck.


It may also be of not that when I create the links in CRX I get the message saying "Your current configuration contains multiple starting points. Please be advised that this is generally not supported." I have no idea what that means, but just pressed ok.