I have a database that tracks exhibitor orders for tradeshows. I need to add a new feature that would allow a user to choose items from the customers orders and create a work ticket. The work ticket would be used for items that "need to be done". Example customer ordered 3 tables and only has 2 in their booth. The work ticket should only show 1 table. As that is all that "needs to be done".

Currently the main screen that is used to track customer orders contains a portal showing all related records on a layout that is connected to the customer. I plan to use Genx's "select multiple portal records" (http://fmforums.com/forum/showtopic.php?tid/180278/) solution to get me started. What I'm not sure about is the next step....how do I allow the user to update the quantity of the line item on the work ticket without changing the quantity of the original order. This would be necessary in the above example as the customer would still need to pay for all 3 tables (original record needs to stay for invoicing and inventory checking purposes) but the work ticket should only say deliver 1 table to exhibitor. Do I need to create duplicate temporary records and then delete them after the work ticket is printed? or create some kind of text that is editable on the work ticket? I'm a little unsure of how to implement this next step. Thanks.

Phew, I can't say that I followed that.

It strikes me though that this is more of a problem to do with your requirements rather than a filemaker problem per se.

Best bet is to do what you want to do using good old fashioned pencil and paper. That way you will have a visual guide to how many pieces of information you require and where they need to be.

From that you should be able to work out what tables and relationships you might need.

Regards

Phil