Help linking Table and Print report separate

[Fauzi]

Dear Guys


I am new to access and programming . I want to know how to do this in Access 2007 . I have table which contain thousand customer names with field ( Customer_id, Pasport_id, name, address, bank_Id ) and Bank Table ( bank_id, Bank name). Bank table is link with customer table.
In my office i have to make a report per bank which contain 10 ( ten ) names sort by Pasport_id . Problem is i have customer_id , but Pasport_id i got when customer come and give their Pasport number.so it is need another field , autonumber type for sequensial printing.

So first i have to find their bank and when i found it , i input pasport _id . The list that have Pasport id will be printed per bank .
How to do it ? Any Help please , please in detail how to do it





Regards

Fauzi

[June7]

Not clear what your requirements are.

You want only 10 names per bank?

You have Customer_id, Pasport_id, name to sort with, so why do you need to use autonumber field for sequential printing?

What do you mean by 'find their bank id and when i found it , i input pasport _id.' Do you need to do data entry before producing report?

[Fauzi]

yes , i need to entry pasport id

[June7]

Seem to be two processes involved:

1. Entering passport ID

2. Producing report

Can you give a more thorough description of the problems you are having? Data entry should be simple. Your report requirements are confusing.

[Fauzi]

Process is :
1. searching for customer id
2. If found , input their Passport Id
3. Print customer report that already have Passport Id by Bank , the rport maximum have 10 names per pages

Regards

Fauzi

[June7]

1. & 2. Use a form with a search feature. Review this tutorial http://datapigtechnologies.com/flash...tomfilter.html

3. Review this article http://support.microsoft.com/kb/209006

[Fauzi]

Thank you for your help, it really help


Fauzi