A layout and a table are not the same thing.
Both layouts can refer to the same table. A find or portal can limit the records listed to only sold items.
We'd need to see your tables and relationships to say much more.
Thanks for your response! philmodjunk
I have been asked by the company to create another layout to display all sold works.
Can you recommend a simple way to bring up all sold works through a portal?
Attaching my relationships.
The simplest approach would be just to perform a find for "sold" items. This can be scripted. It can even be set up for a layout where entering the layout automatically finds old items and an OnModeChange strigger constrains any found set to just sold records.
Duplicating the layout will not accomplish what you want.
Portal could be set up for that purpose, but unless you want to show other things on the same layout besides the list of sold items, I don't really see the point.
Am I correct that your products are one of a kind items with a sold field in the products table to show which are sold?
On the other hand, a List view layout based on Invoice Data would list all items that have ever been added to a a layout--and that would seem to be all items that have been sold, that might be all that you need to get your list.
yes, exactly. They are all one of a kind products so we need to track exactly what has been sold.
It sounds like the find search for 'sold' items would work perfectly. Would I create this script and then apply it to a separate table for the layout?
Read my last post again. You don't even need the find. Just base your layout on the Invoice Items layout and you can get a report listing all items sold or all items sold in a given date range, etc. You'll have one line item record for every item sold so this makes what you need simple.