I have a food ordering database for a school. There is a student table and an orders table (one to many). I need to create food tickets showing the student name and the orders they have for a given day. I'd like them to look like tickets that the kids can bring to the servers. So far I can't figure out a way to make reports print in two columns. Nor can I figure out how to keep the body (part with the food orders) from splitting across pages. HELP!

I have a cludgy work around where I use a relationship to aggregate all of the orders into one field in the student table. Then it doesn't have to be a report. Problem is, all students then print even those without orders (tons of extra paper). I've tried doing an omit with the = symbol, but it doesn't consistently isolate empty records.

:bang:

Edited August 28, 200817 yr by Guest

See Help > Creating and managing layouts and reports > Controlling how layouts print > Setting up to print records in columns