hi there. OK, after this first assessment, what they want now as an implementation, further, where, there are x number of employees.
(lets make it 4)
and each employee has a number, when they place an order the number is entered by themselves, so they are managing a particular order/customer.
I forgot now - how should I tell it to link the employee number with the order number so the person can look at what orders/customer a particular employee has dealt with?
any ideas?
I was thinking of adding another field in the order form table called employee number, drag and drop this into the main form? or do u think I should make another new table and form containing the employee name etc... then link that to the order number/customer number?
(lets make it 4)
and each employee has a number, when they place an order the number is entered by themselves, so they are managing a particular order/customer.
I forgot now - how should I tell it to link the employee number with the order number so the person can look at what orders/customer a particular employee has dealt with?
any ideas?
I was thinking of adding another field in the order form table called employee number, drag and drop this into the main form? or do u think I should make another new table and form containing the employee name etc... then link that to the order number/customer number?