Is it possible to have fields that are not editable but instead are calculated based on data in another table?
I would like to have a table with only one editable field - for bar code scanner input. When the bar code is scanned in then the other fields are populated by data from other tables, the record is saved, and the page is ready for a new record (ie for another barcode input).
I make my calculated fields read only and that seems to work
C
captainbiblio author6/11/2013
I make my calculated fields read only and that seems to work
Thanks for your reply. On the "Fields" screen, I unchecked the check boxes for all fields except the bar code field and this solved the first problem. But how to have the record saved automatically (with blank field for next input) as soon as input completed (I believe the scanner provides hard return at end of scan)?