Using more then One number to display the same information

[04061975]

I am hoping someone can help me get my head around this. I have entered in a Order Number ie 44/0008161 and can display this information as well as a Document Number ie 274854.

The Document Number is my FK link between two tables. My question is is it possible to enter in a Order Number only once, then display it on a form with some general details about this Order Number, then if you want more detailed listed, you would then click on a command button that would display another form with these details.

I am thinking that because the Order Number, which is not, a FK is still in the buffer and then when you click on the command button to run the query that I have it can't compare the Order Number with the Document Number. Therefore would I need to remove the Order Number and then set the focus to the field where the Document Number. If this is possible any ideas how I would go about doing this?

 

[Trendsetter]

Your description is not very clear as to what you have or what you are trying to do, but here goes.
If the Order Number only appears in one document then the details of the order will be available from the query that has populated the form with data, you would only need to reference (as a criteria in the query) the field of the order number to populate a second form linked to the data in the initial form.