Jump to content
Sign in to follow this  
Sleepy1972

Showing a field from a found set?

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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/

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.