Dowsey1977
Board Regular
- Joined
- Apr 6, 2004
- Messages
- 185
Hi,
I have imported information from Excel into an Access table. There were 4 tabs in Excel which had user information along with user access rights. So what I did was created 2 tables in Access. 1 with all the names on the 3 tabs and 1 with all the access rights on it (access rights are grouped into 3 areas, and someone could have multiple access rights in more than 1 area).
What I want is a form that has all the user information on it, then a drop down box where you select one of the 3 areas and then it displays a list of access rights in a box below.
I don't currently have anything in the table that shows the users access rights or for which areas, although this information is held in the spreadsheet. The reaosn I haven't done this yet is because I wanted to have 1 record per person, and currently if I was to import the tabs as they are, where someone falls into more than 1 area it would be on seprate tabs and therefore it would create 2 records.
Any ideas?
I have imported information from Excel into an Access table. There were 4 tabs in Excel which had user information along with user access rights. So what I did was created 2 tables in Access. 1 with all the names on the 3 tabs and 1 with all the access rights on it (access rights are grouped into 3 areas, and someone could have multiple access rights in more than 1 area).
What I want is a form that has all the user information on it, then a drop down box where you select one of the 3 areas and then it displays a list of access rights in a box below.
I don't currently have anything in the table that shows the users access rights or for which areas, although this information is held in the spreadsheet. The reaosn I haven't done this yet is because I wanted to have 1 record per person, and currently if I was to import the tabs as they are, where someone falls into more than 1 area it would be on seprate tabs and therefore it would create 2 records.
Any ideas?