Links in a report

[Soegstad]

I have an order database with a with a customer lookup within it.
The customer lookup results in a report.
What I would like to do is for each customer listed in the report to have a link to the orders they have made.
I don't know if this is possible, but how could I sove this problem (also other possibilities if the report link is impossible).
All suggestions are welcome
Thanks for your help.
Mads

 

[Hayley Baxter]

You can have a subreport to list the orders for each customer. If you mean selecting a link on the report to take you to their orders then this would be better done in a form where customers would be your main table and orders would be displayed in a subform. You would then be able to select any order in the subfrom for that customer and view the order itself.

 

[Soegstad]

Thanks for your reply Baxter.
I probably should have mentioned this is the first topic but my database is linked (ODBC) and I'm having problems setting a key for the ODBC link. Therefore I cannot make any references between the tables.
Do you know how to get around this problem?
Thanks.
Mads

 

[Pat Hartman]

Not having a key would only affect the updatability of an ODBC linked table. It would not have any bearing on a join in a query or setting master/child links in a form or report.