new implementation

[Tech]

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?

 

[Rich]

Take a look at the Northwind and Orders samples that come with Access

 

[Tech]

plz don't say that lol. I tried but can't follow much.

 

[cdacey]

1.
You first need two tables, one with employee info and one with
orders info. Create the employee info table first and have an EMP # field (auto number). Then create the orders table and include an order # (use an autonumber) field, other order info fields, and an EMP # field (make this a lookup field that pulls from the employee table. )

2. Create queries on both tables (It's just faster)

3. Create a Main form from the Employee Query, and include the Employee name & EMP # field.

4. Add a subform to this form, select the Orders Query as it's source, and define your own relationship linking EMP # to EMP #, Add all fields in the orders query to the sub form.

5. This should work. Good luck !

Chris