I have a Table with entries of data pertaining to time worked on a project. I want different consultants to have their own layout that defaults to data they input previously and also I want them to have the ability to enter new data that will default to their ConsultantID. Each of the layouts created for each consultant will populate a "Main" table of all records.
It seems to create a layout that defaults to some particular piece of data (ConsultantID) would be easy. How do I go about doing this? When a consultant clicks Add a Record the ConsultantID field will auto-complete with their ID based on making the layout to default to that consultant's Layout.
Thank you for any help.