JMongi
Active member
- Local time
- Today, 11:29
- Joined
- Jan 6, 2021
- Messages
- 802
Basic Question Alert!
I don't know why I can't remember this from all the tutorials I did, but, isolating this with a simple example should help me lock it in for the future.
So, I'm working on a much simpler database at the moment than the one from my other threads. This on is a basic labor hour tracker. I have the following tables:
My question involves the combo boxes on the main hour tracker form. I want there to be combo boxes for the Employee, Project and TaskType. As you can see, my relationships are based on ID numbers not the actual data I want displayed. These are more appropriately considered list boxes. No data entry, just selection. Just so you understand their intended usage.
Even though all of the fields that I want are in the HourTracker table, am I right to assume I need to base my form on a query that pulls adds the following fields: FirstName, LastName, ProjName and TaskName along with all of the fields in HourTracker so these can be displayed in the combobox?
I don't know why I can't remember this from all the tutorials I did, but, isolating this with a simple example should help me lock it in for the future.
So, I'm working on a much simpler database at the moment than the one from my other threads. This on is a basic labor hour tracker. I have the following tables:
My question involves the combo boxes on the main hour tracker form. I want there to be combo boxes for the Employee, Project and TaskType. As you can see, my relationships are based on ID numbers not the actual data I want displayed. These are more appropriately considered list boxes. No data entry, just selection. Just so you understand their intended usage.
Even though all of the fields that I want are in the HourTracker table, am I right to assume I need to base my form on a query that pulls adds the following fields: FirstName, LastName, ProjName and TaskName along with all of the fields in HourTracker so these can be displayed in the combobox?