>I have a form for entering orders into a table. In the data environment it is related to a customer table and an orderitems table. (As it also is in the database). A command button calls another form which allows the user to print the current order (which comes up as the default in a textbox) or all unprinted orders. Problem is, the child table (order items) doesn't pick up the correct item on the report. If they hit the print command button a second time, it then picks up the correct child record(s). It picks up the correct customer and vendor based on those relations. Tried it with the tables in the report data environment and without them: same problem. Any ideas on what I'm missing here? Many thanks.
You can make the child 'remember' the relationship with a GO RECNO() on the parent table.
Erik Moore
Clientelligence