How to insert record into one to one relationship table

[tabonni]

Hi all

I created two tables - Employee and Folder using MS Access 2002.

Inside Employee table, I got 3 fields:

EmployeeID (Data Type:Autonumber) [primary key]
Username (Data Type: Text)
Password (Data Type: Text)

Inside Folder table, I got 3 fields

FolderID (Data Type: Autonumber) [primary key]
FolderName (Data Type: Text)
EmployeeID (Data Type: Number - Long Integer) [foreign key]

My situation is: After the user login successfully, i will save his
username into session variable. Then, they can select a folder from
the drop down box. After he press the "Add Folder" button. The name of
that folder will be add it into Folder table FolderName field. For
example:

EmployeeID Username Password
10 admin admin
11 somebody pwd

FolderID FolderName EmployeeID
1 Temp 10
2 somebody 11

Can anybody tell me how can I write the SQL for doing it?

Thank you.

[Brian]

"tabonni" <ta*****@yahoo.com> wrote in message
news:fb**************************@posting.google.c om...

Hi all

I created two tables - Employee and Folder using MS Access 2002.

Inside Employee table, I got 3 fields:

EmployeeID (Data Type:Autonumber) [primary key]
Username (Data Type: Text)
Password (Data Type: Text)

Inside Folder table, I got 3 fields

FolderID (Data Type: Autonumber) [primary key]
FolderName (Data Type: Text)
EmployeeID (Data Type: Number - Long Integer) [foreign key]

My situation is: After the user login successfully, i will save his
username into session variable. Then, they can select a folder from
the drop down box. After he press the "Add Folder" button. The name of
that folder will be add it into Folder table FolderName field. For
example:

EmployeeID Username Password
10 admin admin
11 somebody pwd

FolderID FolderName EmployeeID
1 Temp 10
2 somebody 11

Can anybody tell me how can I write the SQL for doing it?

Thank you.

Something doesn't make sense here. Your table design implies a one-to-many
relationship between employee and folder i.e. one employee can have many
folders, but a folder has one and only one employee. But, you have
indicated that you intend to have a drop-down list of folders. This implies
either a one-to-many relationship between folders and employees (so FolderId
would need to be a foreign key on the Employee table), or a many-to-many
relationship between folders and employees (so you would need an additional
junction table with both FolderId and EmployeeId as foreign keys).

Whatever it is you want, you should be able to achieve it using bound forms
without explicitly writing any SQL, but you will need to rationalise your
design first.