jalldridge
Registered User.
- Local time
- Today, 05:43
- Joined
- May 3, 2005
- Messages
- 60
Thought I had understood getting fields from linked tables to display correctly in forms but what I have now is not working.... :-(
If you open the attached db and then run the frm 'frmEnterTimeSheets' you will be presented with a text box asking for a name. Type in Alldridge and click the add work time button. You will now be presented with a list box.
Now what I want to happen next is for the user to select one of the names and then be able to input some time against that user. However after you select the name you want to add times against, the time entry form has a clientID of 0 (there are only IDs of 4 and 8 as shown inthe list box).
I would like to see is the first and last name of the client (concatenated together).
Pointers on how to resolve this one greatly appreciated...
If you open the attached db and then run the frm 'frmEnterTimeSheets' you will be presented with a text box asking for a name. Type in Alldridge and click the add work time button. You will now be presented with a list box.
Now what I want to happen next is for the user to select one of the names and then be able to input some time against that user. However after you select the name you want to add times against, the time entry form has a clientID of 0 (there are only IDs of 4 and 8 as shown inthe list box).
I would like to see is the first and last name of the client (concatenated together).
Pointers on how to resolve this one greatly appreciated...
