I'm not sure I understand but it sounds like a SELECT...UNION might work. Join the two tables together.

>i'd like to build a list from a select between two related archives which contains many fields; i'd like to select a row from this list to obtain the record ID from the header file (excuse my english but i don't use often english)