Lookup Table Question

[Leonidsg]

Hello, I was wondering if I can use a lookup table as an ongoing table for lookups in different tables. For example in my main table I have a field asking which bones you have previously broken. That field is then linked to a table which is just a list of bones, I sometimes add bones if its one that doesn't get broken often and hasn't been included on the list. This method seems easier than making a simple lookup every time. Is this practice kosher or am I going to have problems later.



Thank you
Lenny

[orange]

If you have a table of bones--eg LkpTblBones with structure

BoneId
BoneName

see http://en.wikipedia.org/wiki/List_of...human_skeleton

You could use this table for your lookup. Your broken broken bones by Patient would refer to the BoneId in the lookup table.

Good luck

[Leonidsg]

If you have a table of bones--eg LkpTblBones with structure

BoneId
BoneName

see http://en.wikipedia.org/wiki/List_of...human_skeleton

You could use this table for your lookup. Your broken broken bones by Patient would refer to the BoneId in the lookup table.

Good luck

Does that mean I am okay using a lookup and table in that manner. I was worried that I may setup too many relationships.

Thank you.