The form embedded in the subform control will be based on a query joining
the SalesSalesperson table with the Salesperson table. The foreign keys in
SalesSalesperson will point to the Sales record and to the Salesperson
record (for information like, Salesperson's name).
It would be in the SalesSalesperson record, the one that ties a particular
Salesperson to a particular Sale, that the salesperson's contribution to
this sale would be stored. I am assuming different salespeople can make
different contributions to a given sale, and not necessarily the same
contribution to some other sale.
Use a ComboBox to select the Salesperson, and a textbox to enter the
contribution. The Salesperson Name will be displayed in the ComboBox, but
the id field of that salesperson will be stored. The Combo Box wizard will
lead you by the hand through setting it up.
If that doesn't help, please clarify what is not clear and I'll try to
respond.
Larry Linson
Microsoft Access MVP
"RR" <te**********@yahoo.com> wrote in message
news:6u******************@fe2.texas.rr.com...
Could you explain the last paragraph in a different way? I think I
understand the first part, but not the last.
Your salessalesperson table will have filelds for their "costs" to the
sale? "Larry Linson" <bo*****@localhost.not> wrote in message
news:XmB4d.8944$Bg5.2797@trnddc07... First, you'd need your tables properly designed... a Sales table, a
Salesperson table, and a SalesSalesperson table. What you have is not a
"many to one" but a "many to many" -- that is multiple salespeople per sale, but a salesperson can also be involved in multiple sales.
The SalesSalesperson table would have foreign keys pointing to the
record in the Sales table, and to a single Salesperson. But there could be (will
be) many entries in the SalesSalesperson table for a given sale or a given
salesperson.
For a particular sale, I'd use a Subform whose RecordSource was a Query
on the SalesSalesperson table, joined to the Salesperson table. I'd use a
ComboBox in the Form embedded in the Subform Control to choose the
salesman... you may want/need to use some VBA code to create the new
entry in the SalesSalesperson table and to requery the Form embedded in the
Subform Control.
Larry Linson
Microsoft Access MVP
"RR" <te**********@yahoo.com> wrote in message
news:dv*****************@fe2.texas.rr.com... What would the proper way be to enter a sale, then be able to enter 1
or more sales persons, their "costs" to the sale, and their commission on
the sale?
Then after its been entered, have all the information show up as a
part of the sale?