Linking for to several entries in other one
Is there a way to link to more than one entry in another table?
Allow me explain myself. Lets say I have a from payments which I want to charge to a project. The easy part is when that payment is fully for a project. However, in many occasions a payment is made that correspond to more than one project. Any way that I can think of to do that involves inputing the data more than once which is very error prone.
Would there be a way to have in the form another form or some other way to deal with a list of pairs project-quantity in the case where there are more than one?
I guess the same question would be to be able of dynamically change the fields in a form. Thus, we could have just one project-quantity or as many as needed.
All this does not seem very elegant to me and I suppose there has to be an elegant way of doing this. It just eludes me.
Alberto