I'm struggling to get my head around access. I'm trying to create a purchase order form but in trying to automate as much of it as possible I have hit a problem I could do with some help on.
The form pulls its data from the purchaseOrder table (thats all fine) and it also allows the user to select who they are from a combo box (in a related table userList). Again that works ok. The problem is I want to update the Department comboBox (its a comboBox right now, but it doesn't have to be, its just where I started from) on the form automatically when the user selects who they are. After all the information is already in the database so why should the user have to fill that in again every time they create a purchase order? The department the user belongs to is in another related table (related to the userList table)
I've tried various things but I'm just not sure how I should do this in access... any help appreciated.
Database is something like this:
poNumber,... a whole bunch of fields ..., raisedBy
1 ,..............................................., excel support
id, lastName, firstName, jobTitle , fullName , department, etc etc
1 , support , excel , IT Support , excel support, IT ,
(Note: fullName is a calculated field of firstName + lastName)
1 , IT