problem with relationship

[mugen_rsx]

I have attached a image here, hope it will help!!

My problem is on the bottom right, where the table called "size"-->"model". This is actually a very simple Material Used database. From left to right, user have to input material name, then their color, then Usage of it. (I also add the invoice, so I can track a specific invoice # used what materials). Here is a part that I got stuck........

each model have more than one sizes, so I split the model name and size into two different tables, and also, these model names and sizes are fixed.

When i input the model in "Material..."(Entry ID table), I cannot recall the sizes of that model. I know what I have done on the picture are wrong, but I really couldn't find out a way by myself

Thank you

 

[daveUK]

You should be entering new details in a form.

You should have one combo box for Model and another for Model sizes. These should be set up as cascading combo boxes so that after you select a model, only the sizes available for that model shoud appear.

Search the forum for cascading combo boxes to see examples.

HTH