View Single Post
 
Old 04-24-2023, 10:49 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Your design is not meant for getting info from your tables easily. Consider a design I applied as example of better one.

In Salaries Table, you preferably hide the column RecNo - it being visible only confuses user.

About getting info sorted, for easier cases you can use sort and filter options on Salaries Table. For more sophistcated cases, you can design report sheets, where proper Salaries Table RecNo value for report table row are calculated to hidden column in report table, and like on Entry sheet, this RecNo value is used to read wanted data from Salaries Table.
Reply With Quote