Well, no, I'm not sure... I'm trying to figure this out as I go, so I'm not
well versed in methods.
Ok, here's one context (there are others, but we'll go with just this).
I have a table called SalesCodes with list all our possible sales products.
Another Table called CurrentDeals list package deals. They have package
names, then the related Sales Codes for each Package Deal is listed in that
deal's record.
Now, on the Sales Order entry form, I want the user to be able to use a
lookup to select the approprate package deal (from the CurrentDeal table).
Here's where the question comes into play... I would like the Orders Subform
to auto-populate with the appropriate Sales Codes which are associated with
that particular package deal.
Does that make sense? Basically, once the package is selected, I'd like it
to look at the record in the Current Deals table, find the appropriate Sales
Codes, and create 1 record per Sales Code in the subform.
Thank you very much!