Showing a field from a found set?

[Sleepy1972]

I'm writing what in essence a simple database but have got stumped at the following.

The database is to track the movement of certain film rolls in and out of two locations. There is a record for each roll 'roll numbers' which have a 'movement order no' assigned (separate field) as they get shipped about.

I have to produce a document to authorise this movement. How can I create a field that shows all the 'roll numbers' for a 'movement order no'. I know I should be able to but can't get the function right.

I've created a report which will count the number of rolls per 'movement order' which is great for costing but I need the specific 'roll numbers' to create the paperwork to shift them.

[comment]

It sounds like you should have three tables: one for orders, one for the rolls and one for the order items. Same as invoices, in essence:

http://fmforums.com/forum/showpost.php?post/309136/

[Sleepy1972]

Great, thanks for this. I can see what I was doing wrong now (I need to experiment a little but..). I knew it should be relatively straight forward.