If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup field and Relationships
I am having trouble understanding a design concept. I am setting up an
employee database for the first time. At issue is how to handle the actions entered into a log table. I have a table for employee's info, and log table that i am using to keep track of actions performed on employees, i.e. new hire, raise, termination, etc. It seems appropriate to have the log table include a FK for an actions table with all of the possible actions. in the design view of the log table, i can see that the action field is set as a combo box with a row source of the actions table PK, yet I don't see a relationship in the relationships view. Is this a problem? I tried dragging the field over to establish the relationship, but the field properties don't match. (log table = text) Changing the data type to number wants to delete all of the entries. So it seems like I should do an update query to change the text to the code of the FK from the actions table to create the relationship. Bottom line, why is there no relationship, and does it matter long term? thanks in advance. |
Thread Tools | |
Display Modes | |
|
|