Hard to search on something I can't even explain. Attached is the database I'm working on. I want have the Employee_Name to be in the Full_Name in the subfolder. Which the only way I could think of is to have the Full_Name control Source =[Forms]![WorkOrder_Main]![Employee name]. I want to be able to automatically add the Hourly_Rate and OT_Rate for that specific user in the Full_Name. The reason why I'm building the DB this way is that some of the Project_Numbers have different Employee_Name wages. I need to have the Rates auto fill by the user name in the Full_Name field when selecting the Employee_name in the main form. See attached DB.
View attachment Capital Projects.accdb
Please reply back if you need me to explain more.
Thank you very much for your time.
Please reply back if you need me to explain more.
Thank you very much for your time.