Select Code to Download

Folder_ID     Auto-Number (Long Integer, also it is the Key value so n
+o duplicates are allowed)
Folder        Text (Field size 255, Required =>Yes, Allow Zero length 
+=> No)

Perms_ID    Auto-Number (Long Integer, also it is the Key value so no 
+duplicates are allowed)
Account    Text (Field size 255, Required =>Yes, Allow Zero length => 
+No)
Type        Text (Field size 50, Required =>Yes, Allow Zero length => 
+Yes)
Folder_ID     Number (Long Integer, the Key value from table1)

Folder    from table1 (Folders_table)
Account      from table2 (Perms_table)    
Type      from table2 (Perms_table)