I am displaying a portal window, which when a line item (UPC) is entered, it (the UPC field in my Items DB) does a lookup of an inventory item (in my Inventory DB). When using the [Full Access] log-in, the portal window refreshes after each line item is entered accurately displaying the new line item. When using any other account access (i.e. Data Entry only), the portal window fails to refresh automatically after each line item is entered.

Does anyone know a work around or why the portal window behaves differently with access priv's? Thanks for any help!

hmm never met this problem before, but i did meet a similar one when i was implementing a business processing cycle. Filemaker was really slow to respond to change made on a table if on the same layout there is another instance of the same table.

in my business cycle solution there was 4 of the same table on the same layout.

Refresh just fails terribly, as if it does nothing! So what i did was i use script step to go to a different layout, and then go back to original layout. this fixes the problem... i had to insert this script to any other scripts that will make change to the current business task's status.

Thanks for the response. I'm using the database as a test POS system. Users will scan items at the register one after another, so I am not using any scripts to create new records. The only field they have access to is the UPC field so that when they scan an item it automatically does the lookup and then jumps to the next UPC field (next portal row). I can't use the Exit Record script step and I don't kow of any other way to "script" the scanning of items in a cash register type situation without really slowing the whole process down. I've tried putting a calc field in to make the screen refresh and the calc field re-calcs after each new record, but the row still does not refresh when using a Data Entry Only user.

Any other suggestions or ideas would be greatly appreciated!