The cycle of everyone a great god, and there is a Access query problem, want to ask, how to achieve-CodePudding

Access database with two tables, one is our letter information, one is the other letter information,
Need to pass the query number, our letter out all related to this letter Numbers (directly or indirectly) the number of the letter,

Our letter information:

(Ref Number Number may be many-valued reference letter, from the letter Number or other information in our letter letter information in the file Number, I add a multivalued refer to columns,

The present question is that how to use the query number, our letter out all related (directly or indirectly) the number of the letter, now my idea is through our correspondence number in the reference letter number, all queries related to this letter our correspondence with each other, and then through the check to the letter of reference letter number (may) for multiple values to query our and the other related letter number, query over and over again, until there is no reference to letter number, don't know how to operate this cycle query,

Or you great god is there a better way, by querying a letter number to query all the related letter codes in the two tables, thanks a lot!!!!! The grateful
PS (I added more than one value in it refer to the column, if after insert hyperlinks, there will be a problem,)

CodePudding user response:

Legend as unclear what do you want to express

CodePudding user response:

reference 1st floor ayalicer response:

legend as unclear what do you want to express the content of the

Very thank you for your reply!
I want to express meaning by letter number, the query to the reference letter, to check the reference letters continue to query the reference letter, until there is no reference letters, to finally put all the letters displayed,

Pictured above CGGC - PAHW - TEC - 0174 records, this reference letter has 2:14151-1/10 and CGGC - PAHW - GEN - 0118, I want to by CGGC PAHW - TEC - 0174 queries to the two letters, if CGGC - PAHW - GEN - 0118 (or 14151-1/10) and other reference letter, will continue to query, until no reference letters, finally will display all of the letters,

Thank you, don't know if you have to understand I want to express meaning,

CodePudding user response:

Database access is right, I'll give you to access the plate

CodePudding user response:

Only an honest one by one check
Behind with letter, check for conditions, to obtain the value of the two fields empty no matter, have a bean size according to make space value, into a temporary array, redo condition query, query to the content into a temporary table or array, after taking the data release
Don't be afraid of circulation