parent/child row relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

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