hi all, new member here and also new in access and thats why i need your help.
so, i have to make a project thing it called "many to many". i need one table named it for example A that will have 4slots(for customers,addresses etc) and another table named it B (for staff they buy). for example lets say that the staff that they buy are from A to Z. i want when i add a new customer in table A to be able to choose one or more than one of the staff(AtoZ) he buy. Also i want when i open the staff(AtoZ , in table B) to choose one for examble Z and then to see which customers had bought Z staff from me.
sorry for bad english or bad explanation..
i tryed to make a project myself and i made:
table1: customer, customer name, address
table3 : staff, name of the staff , info for the staff
table2 : this one connects the customer name with the name of the staff.i choose of the customers i have added in table1 and one of the staff i added one table3 and just put this in line.
This way i have done it, after every add i make i have to go in table2 and connect the staff. i dont want to do this. i want to have one more slot in table 1 with what staff customer bought and one in table 3 which customer bought this staff. so dont have to go to table 2 and connect the customer-staff.
is there anything i can do? anyone has made something like this so i can take it ,rename it and do my job?
hope u can give me a hand..
so, i have to make a project thing it called "many to many". i need one table named it for example A that will have 4slots(for customers,addresses etc) and another table named it B (for staff they buy). for example lets say that the staff that they buy are from A to Z. i want when i add a new customer in table A to be able to choose one or more than one of the staff(AtoZ) he buy. Also i want when i open the staff(AtoZ , in table B) to choose one for examble Z and then to see which customers had bought Z staff from me.
sorry for bad english or bad explanation..
i tryed to make a project myself and i made:
table1: customer, customer name, address
table3 : staff, name of the staff , info for the staff
table2 : this one connects the customer name with the name of the staff.i choose of the customers i have added in table1 and one of the staff i added one table3 and just put this in line.
This way i have done it, after every add i make i have to go in table2 and connect the staff. i dont want to do this. i want to have one more slot in table 1 with what staff customer bought and one in table 3 which customer bought this staff. so dont have to go to table 2 and connect the customer-staff.
is there anything i can do? anyone has made something like this so i can take it ,rename it and do my job?
hope u can give me a hand..
