im displaying multiple records from different tables in text boxes,i have fields as item code (assigned to customer) description n quantity.now when running the program i move records,the customers who have been assigned the item code their record is being displayed only but who haven't been assigned with item code are not being displayed. so i want to know is there any way out to display all the records one by one when i press move next'button???

what you want to display if item code is not assigned .

Instead of displaying from multiple tables, create a view based on your desired logic and pull records from the view to display in the application.