Relationship Problem

[Russell Proctor]

Hello,

I am developing a solution that tracks printed jobs.

Each job may have one or more products of a varying total.

Each product can have multiple call-offs.

I need to track each call-off in relation to the product and job and track each remaining balance.

At present I control this through the following relationships.

Jobs (job_id_pk) to Products (job_id_fk)

Products (prd_id_pk) to Call Offs (prd_id_fk)

Is their a better way?

All help/ideas will be appreciated.

Regards

[comment]

At present I control this through the following relationships.

Jobs (job_id_pk) to Products (job_id_fk)

Products (prd_id_pk) to Call Offs (prd_id_fk)

Is their a better way?

I don't think so. What problems are you experiencing?