Tintagel

Hi Bob, Sounds very strange. Maybe if you could post a screen shot, it might be possible to see what is going wrong. :qwery:

Clearly you need to create a linetype and order field in your quotes table, then do a bit of nifty scripting to control the portal. You'll be able to manage something like 1, 2 and 5 with scripts. 3 could be trickier - you'd be better using a preview with sub-summaries in the quotes table, rather than using a portal.t just blows the data model totally. 4 just seems to me like a case of fuzzy thinking. Why ever would you want to have notes *in* your quotes table?! Attached to it I can understand, but putting them *in* the portal?! :badidea:

Of course there's always repeating fields. But LaRetta's suggestions are much better. Especially the first, becaase that is so easy to set up and is where FM really shines!!

If you are getting the message now even with dbs you created yourself, that means something in your system set-up has been changed since those db's were created. Maybe you changed the date formats? Or the default language or other regional settings. Either way save as clone like Andy says will work. Or just put settings back the way they were.

Pat, I am not getting that here. Table view with over 4,000 records is displaying correctly. Maybe it is an operating system issue. Or a version issue. I am using FMPv6 here.

I'd take it that the "!=" in the above is meant to refer to the < > or not-equal-to operator?! Alternative would be - Case(not LineItemType = "Product",1, ...etc