By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,385 Members | 1,822 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,385 IT Pros & Developers. It's quick & easy.

Table relationship: Bill & Fees tables

P: 12
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.
Sep 24 '08 #1
Share this Question
Share on Google+
1 Reply

P: 167
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.
Sep 24 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.