need help in resoving 2 many to one relationships

[thepreacher]

Problem,
A transaction has an ID and Will also cause many Withdrawal IDs ( for now i am limited to 12 but you may consider unlimited Withdrawal IDs)
the same transaction ID will also be linked to many withdrawal amounts also 12 for now)

The withdrawal code and transaction ID is needed to retrieve the Withdrawal amount.

I need help to design a table the helps to easily store and retrieve the data.

Would be grateful if an explanation is provided for any solution.

Thanks

[VGR]

easy.

make that relatioship table :
create table transac_to_withdr(id_transaction integer not null,id_withdrawal integer not null,withdrawal float not null);

the two keys can not be unique
the withdrawal amount is an attribute to the relationship, thus it's a field in the relationship table
This said, I wonder why you need a withdrawal id in the relation, the withdrawal amount is enough for the moment unless you've more withdrawal attriobutes, of course. As set up, the table could as well be named transaction_amounts(id_transaction integer not null,withdrawal float not null);

regards

[thepreacher]

Thnks VGR for your help. Perhaps a  scenario will better explain my problem.

-----
A person transfers say $500. One of the effects of this transaction is that an ID is generated. However the person wants to withdraw this amount in 5 equal installments (ie 100 x 5). A business decision is to assign each of the installments an ID such that the person will have to supply their Transaction ID and Withdrawal(or Installment) ID before they can collect their cash. With each successful withdrawal, the used Withdrawal Id is flag as used and hence cannot be used again.


Transaction ID --->Withdrawal ID--->Withdrawal Amount
                               Withdrawal ID--->Withdrawal Amount
                               Withdrawal ID--->Withdrawal Amount
                               Withdrawal ID--->Withdrawal Amount
                               etc ....

Withdrawal Amount is the same for different Withdrawal IDs
-----
I hope this makes things a little clearer.


warmest regards