parent/child row relationships

[Guest]

I have a database that contains several rows for one record. (I didn't set
this up) Anyway, there is a header row that has one or more detailed row,
using the same ID number. There are unique keys that are in sequential order
for each row. I need to be able to bring up the header row on the top of the
form, and all detail at the bottom of the form

 

[Guest]

You gonna need form and subform with Master/Child link on the Record field
(ID number).
Use these queries --
Van_Work_Header ---
SELECT Van_Work.Record, Van_Work.Sequential, Van_Work.Text1, Van_Work.Text2
FROM Van_Work
WHERE (((Van_Work.Sequential)="1"));

Van_Work_Details ---
SELECT Van_Work.Record, Van_Work.Sequential, Van_Work.Text1, Van_Work.Text2
FROM Van_Work
WHERE (((Van_Work.Sequential)<>"1"))
ORDER BY Van_Work.Record, Van_Work.Sequential;

 

[Guest]

I think you should redo your structure to the way these two queries presents
the data.