Pls, see if you can help me on this:
I have a client table with PrimaryKey, clientname, address, date of birth. Another table with PrimaryKey, phone numbers like Celular, work phone, home phone.
I want to show all these info in the same report page. I created a query with these two tables and if client has 4 telephone numbers i can see 4 lines, repeating the main table data and each phone in a different line. I created a report based on that query. So, when I print the report I get 4 pages. The reason why I created a separate table for phone numbers was because I did not want client to type each time the name of phones like home, work, etc. so in the form I created a subform with a list box so client can only open list box and select which type of phone he wants.
I accept any suggestion to help me solve this problem.
I am not sure if this is a query problem or report problem. Tks for your attention.
I have a client table with PrimaryKey, clientname, address, date of birth. Another table with PrimaryKey, phone numbers like Celular, work phone, home phone.
I want to show all these info in the same report page. I created a query with these two tables and if client has 4 telephone numbers i can see 4 lines, repeating the main table data and each phone in a different line. I created a report based on that query. So, when I print the report I get 4 pages. The reason why I created a separate table for phone numbers was because I did not want client to type each time the name of phones like home, work, etc. so in the form I created a subform with a list box so client can only open list box and select which type of phone he wants.
I accept any suggestion to help me solve this problem.
I am not sure if this is a query problem or report problem. Tks for your attention.