Hi everybody,

I have a junction table that is supposed to have

OptionID MakeID ModelID and some price fields.

I have one OptionID and one MakeID selected and I can have multiple ModelID selected.

I want to have a view (or CA) which would have records for each of them, e.g.

selOptionID selMakeID selModelID1         Price fields
selOptionID selMakeID selModelID2         Price fields

If I already have a record in my table, I want to retrieve it, otherwise prepare a record to fill.

Also I want to be able to cancel at any moment and therefore new records would not be added.

I'm not sure how to construct such view or CA.

Any ideas?

Thanks in advance.