Many2many Problems
Oct 27, 2006
i have two databases setup. the first is called "groups" and the second is called "people". i want to be able to view people by groups and groups by people. the problem i've having is that one person can hold several positions within a group. for example one person could hold the position "leader" of the group and also hold the position "host" if the group is meeting at their house. when i view the group i'd like to be able to see each postion that is being held by people and when i view people i'd like to see which groups they are associated with AND what position(s) they hold within that group.
does anyone have any suggestions how i should set this up and also what my forms need to do in order for everything to work smoothly?
thanks in advance.
john
View Replies
Aug 1, 2006
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..
View 2 Replies
View Related
Dec 27, 2006
I'm trying to create a little dbase for personal keeping track of a number of companies I deal with, so that i store their details and also the products they distribute.
In more detail, I want to have 'fixed' product categories, which will be assigned to supplier, and each category will include the product models I have set, including their details (such as price, manufacturer, country of origin, etc).
My point is to be able to create several customised reports and listing:
1. All product models I have in a category including their details.
2. Report per supplier to view their details and the products they distribute
3. Certain product models in a list with their local distributor (companies I deal with).
I assume it involves a couple of many2many relationships, however I have created a file in MS Access but never managed to have it work properly.
Any1 have an idea, or template maybe?
Regards ;)
View 2 Replies
View Related
