What kind of relationship do I need between a table created for "bills" and one for "fees", where there can be more than one fee per bill. In the "fee" table there is a "Fee Name" and a "Fee Charge"? On the "bill" form I use a combo box and I would like to be able to add to the "fee" table using this combo box.
-
-
I believe you will need another table called tblBillFee.
This table needs to have two fields:
bID (PK),Number, Long
fID (PK),Number, Long
bID must be connected to table Bills and it's Bill ID field.
fID must be connected to table Fee using Fee ID.
Also, fID should be Combo-box using Table Fee as source for the list.
That way you would select a fee from combo-box, and Fee name and Fee charge will be pulled automaticly.
Comment