small table help required

[locutusofborg]

Hi Guys hope you can offer some assistance:

I have been asked to set up a few tables in an access db by my boss. He has given me a functional spec that looks something like this.
field Format comment
ContainerCode 10 chrs unique code
Containertype 1 chrs type of container
0=box 1=bin 2=bag 3=eurobin

ContainerStatus 1 chrs 0=empty ,1=in use , 3=offloading

so the problem is do I need a new table for the container type field that is somehow linked ? the table above will have a 2 for example in the container type field this means by my definition that it is a bag. Do I need a table to hold the values corrosponding to the number and how do I link and set the relationship back to the main table.

The same thing applies to the field called status as this is exactly the same senario.

Any help would be appreciated as I am new to this type of thing.
Much appreciated guys

Rgds, Locutus of borg

 

[annsolomon]

I'd include the container type info in tblContainers. After all, the container isn't going to turn into a different type day to day, is it?

In tblContainerStatus I'd include the ContainerCode and the StatusCode and link your two tables on the Container Code. By the way, I'd select the Lookup Wizard when setting the Data Type of ContainerStatus. When you get the popup screen select the option to type in the values then you can enter your 0, 1, 3 and the user will select from these values rather than having to type in the code. Ann

 

[johnnymac43]

You asked a more detailed question about this project on Feb 5, and were given a detailed reply that you have not acknowledged. What gives?

John

 

[locutusofborg]

Thanks for the help guys , will follow your advise annsolomon. Kinda new to this whole database thing and still trying to find my way a little.

Thx again , big help.