Need to create "Address Label" Report with parameter Works Order No:

[tajammul74]

Hi all,

I have created a label report in crystal report like the one;

Due Date: ___/___/____
Customer: ______________
Contract No: _____________
Part No: _______
Quantity: _____
Value: £______

I have got Tables;

COMPANYS -> for customer record
Sales_Order_Lines -> for Due Date,Contract No:,Quantity & Value
Part -> for Part No:

I have also included the Works Order table as well,as i need to create a parameter value so that my report ask user to keyin the Works Order No: then list of Labels get printed related to the specific works order no:.

Now how i can make relations between the above defined tables so that i can get specific lables according to the works order no:
IF YOU COULD PROVIDE ME THE SIMPLE SOLUTION AS I AM A LEARNER...

 

[Madawc]

Your database, how is anyone else supposed to know the links?

It might be via some other record that has no data you need, but is the necessary connector. Where I work, we have special records to show that a particular customer is linked to a particular account, there being nothing on account or customer that would show this.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10