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

 

[Pat Hartman]

I am having troubl understanding the structure. If this is an order entry application, you are missing a table. You would need a table that defines the available items. The table you have that is being linked to Invoice seems to be serving two purposes. That of defining material and also of linking material to an invoice. If this is how you keep inventory, I would expect serial numbers for the material and quantity of only 1. Normally, once inventory is received, it looses its individual relationship with an invoice unless there is something like batch, lot, or heat or a serial number to relate it.