You can do this if you use a form and subform.
The main form is for the department, the subform shows all the invoices for
the department.
Use a combo box in the main form for the user to select the department.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"hobbit2612 via AccessMonster.com" u27332@uwe wrote in message
news:a2a5e43776a84@uwe...
Hi I wonder if someone can help me please with a problem that's been
baffling
me for days.

Basically I have two tables, one that shows different departments, the
other
shows invoices allocated to that particular department. They are linked
via
an InvoiceID using a One to Many relationship.

What I would like to do is to create a continuous form which shows all the
invoices allocated to the Departments, but without showing a duplication
of
the department name.

e.g.

DEPARTMENT INVOICENO.

Wages 1
2
3

Personnel 1
2


I know that this can be done relatively easy on a report by hiding
duplicate
values, but can anyone offer any guidance please on how this can be done
on
form?

Many thanks

Chris

--
Message posted via http://www.accessmonster.com