help with table setup

[cooh23]

Hello,

I am having difficulties normalizing my tables. So far, i have 4 tables

tblODF:
- ODFNumber (PK, manually enter ID)
- UserName (txt)
- QueueID (number)
- ScanDate (date)
- Status (text)

tblEmployee
- EmployeeID (pk, autonumber)
- UserName (txt)
- LastName(txt)
- FirstName(txt)
- Extension(number)

tblQueue
- QueueID(Pk, autonumber)
- Queue (txt)

tblStatus
- StatusID(pk, autonumber)
- Status(txt)

I am also having problems setting up the relationships

I want to setup a query and i want all these data to appear:
- ODFNumber (txt)
- UserName (txt)
- ScanDate (date)
- Queue (txt)
- Status (txt)

I am really stuck in setting up the tables and their relationship.

So in short, help

Thank you,

(some of you might recognize this project)

 

[boblarson]

In your tblODF change this:
UserName (txt)

To:
EmployeeID Long Integer (FK)

and this:
Status (text)

to this:
StatusID Long Integer (FK)

 

[cooh23]

In your tblODF change this:
UserName (txt)

To:
EmployeeID Long Integer (FK)

and this:
Status (text)

to this:
StatusID Long Integer (FK)

btw, what is FK?

So in the relationship, do i set it up this way?

tblODF -------to ------> tblEmployee
EmployeeID --------to------>EmployeeID

tblODF ---------TO------> tblQueue
QueueID------------------>QueueID

tblODF ---------TO------>tblStatus
StatusID------------------>StatusID

I just wanted to make sure that everything is right before I start building the forms.

Thank you again.

 

[boblarson]

FK is foreign key. What it does is store the primary key of an item from a different table. You don't want to store the text as you can pull that together at anytime via a query. What you store is the primary key of the item in that other table.

Does that make sense. And the fixed form I gave you yesterday was exactly that. I had changed things so that what was stored was the foreign key and not the text.

 

[cooh23]

FK is foreign key. What it does is store the primary key of an item from a different table. You don't want to store the text as you can pull that together at anytime via a query. What you store is the primary key of the item in that other table.

Does that make sense. And the fixed form I gave you yesterday was exactly that. I had changed things so that what was stored was the foreign key and not the text.

ahh.. got it.. thank you