I am an Access novice...so please be gentle..

I have a database of patient procedures. The number of procedures for each patient varies. I want to display all currently stored procedures by patient and allow the user to update an existing procedure and/or create a new procedure.

I think the flex grid control might do this but i can't figure out how to use it. Any suggestions would be very much appreciated.

Hmmm. I am not exactly new to Access but the term "flex grid control" is new to me. I do not know what this is but it sounds to me like you need a Form/Subform arrangement. Patients on your Main Form, Procedures in your Subform.

Create a Main form based on Patient information. Create a form (probably datasheet) for Procedures. Using the Wizard create a subform on your main form, choose your subform form for the subform when asked by the Wizard and then follow the rest of the steps in the Wizard. When you are finished you should be able select a Patient and see her/his Procedures in the subform.



[This message has been edited by Jack Cowley (edited 03-03-2001).]

Flex Grid control is a reference to a psuedo Excel, pivot table kind-a-control. Very cool in VB, but here, we don't need to go that far.

Creating two separate tables, one for Patients and one for procedures should work for you. Have a Key field for patient ID and make it primary in your patients table.

Relate the two tables in a one-to-many relationship in the relationships table.

Create a form with the patient info, and then create a subform (keyword) for the procedures.

HTH