alanna101207
Technical User
I don't know if this is the proper way to approach this, but with my limited knowledge of access, this is all I can think of. This is very detailed, so please bare with me.
I have 2 tabels "tbl_Charges" and "tbl_Rates" with "ChargeID" and "RateID" being the primary keys. The "tbl_Charges" has a set of Charges for items such as Delivery Charge, Rush Charge, Document Prep Charge etc...each client has a different set of rates...ie..."Standard Rates", "VIP Rates" etc...
In order to join these 2 tables I used a Join Table "tbl_RatesChargesJoin". This needed it's own primary key "RateChargeID". I need this to insure Integrity the way I have it set up.
I have a form (frm_NewRates) that I am building that will be for a manager to enter new rates. He opens the form, clicks a command button that starts the record with a new "RateID". He then has to enter a new "Rate Name". I want to have a Command Button or something that would be clicked, and then automatically populate the sub form with each Charge from the "tbl_Charges". He then would only have to enter the amounts next to each charge that is already there in the "frm_NewRates" subform which has a record source of the "tbl_RatesChargesJoin".
After the research I have done on Access I have decided to try to use the INSERT INTO code to do this, this would add new records in the join for each charge, however, doing this from a form seems more difficult than I imagined mainly because of the quotations I believe. It looks like I would need to use INSERT INTO, then SELECT or VALUES...just not sure.
Could somebody point me in a better direction, if there is one, or point me to an article or post that tackles something similar to what I amtrying to accomplish. Thank you very much.
I have 2 tabels "tbl_Charges" and "tbl_Rates" with "ChargeID" and "RateID" being the primary keys. The "tbl_Charges" has a set of Charges for items such as Delivery Charge, Rush Charge, Document Prep Charge etc...each client has a different set of rates...ie..."Standard Rates", "VIP Rates" etc...
In order to join these 2 tables I used a Join Table "tbl_RatesChargesJoin". This needed it's own primary key "RateChargeID". I need this to insure Integrity the way I have it set up.
I have a form (frm_NewRates) that I am building that will be for a manager to enter new rates. He opens the form, clicks a command button that starts the record with a new "RateID". He then has to enter a new "Rate Name". I want to have a Command Button or something that would be clicked, and then automatically populate the sub form with each Charge from the "tbl_Charges". He then would only have to enter the amounts next to each charge that is already there in the "frm_NewRates" subform which has a record source of the "tbl_RatesChargesJoin".
After the research I have done on Access I have decided to try to use the INSERT INTO code to do this, this would add new records in the join for each charge, however, doing this from a form seems more difficult than I imagined mainly because of the quotations I believe. It looks like I would need to use INSERT INTO, then SELECT or VALUES...just not sure.
Could somebody point me in a better direction, if there is one, or point me to an article or post that tackles something similar to what I amtrying to accomplish. Thank you very much.
