Parts and Models List (1 Viewer)

[mreinsmith]

I've been reading about how to use a junction table to do this but I just can't seem to get it straight

I have a list of parts and a list of models

Can someone walk me through the steps of creating the relationships and creating the form for data entry

but most importantly I need to be able to import a csv with that data

If there is a good post with a walk through, maybe point me to that?

Thank You

Matt

 

[MadPiet]

How are Parts and Models related in the real world? A Model consists of one or more Parts?

Model--(1,M)--ModelParts--(M,1)--Part
Say the primary key of Model is ModelKey and it's a unique integer. And Part's Primary Key is PartKey. So, by definition, PartKey and ModelKey are both unique. Then the primary key of ModelParts is the combination of those two keys (ModelKey, PartKey)

Creating the relationships? go into relationship view and drag & drop the ModelKey from Model to ModelParts on top of ModelKey in ModelParts. same with Part-->ModelParts.