On 10/13/07, Chuck Pelto <[log in to unmask]> wrote: > I just moved to FMP9a. > > I'm noticing that calls made to tables by using their name, e.g., > show every record of table "aTable" whose cell...... > > ....doesn't work. Saying table 1 works. But not calling the table by > its name. Tables and layouts are entirely different. A table is the complete underlying data table. It has no found set, no sort order, no current record. It is always in creation order. You cannot "show" a table. You cannot "find" records in a table. You can get and set data VERY quickly using table references but you must refer to the records by ID or some other identifier that correctly idenfiies the record you want to work with. From your description it sounds like you may want to use layout references. Remember that you must specify the window. A Filemaker database may have any number of open windows and may have any number of layouts, each of which can be based on the same or different tables. each layout (if based on a different table occurrence) can have a separate found set and separate current record. A window can have a current layout and thus a current record associated with the layout. But frequently you will be better of accurately specifying the window, layout, and record you want to use.