A Form As a Field? =\

#1 (**permalink**) 28-Jul-2006, 08:42 AM

First, I have a main form. In this form you add all of the product
information. Everything is happy. However, now, I need to add something
else. I need to add Pricing History to the form in a special way.

Pricing History has the following fields: Pricing ID, Product ID,
Effective Date, MRC, and NRC
Each Product will have, at most, five Pricing History entries.
The Pricing History is displayed as a subform within the Product form.
Does that make sense? Each Product will have it's own unique Pricing
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14061-a-form-as-a-field.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14061
History subform.
I haven't a clue on how I should begin. Can anyone help?

Thanks,
Jillian

#2 (**permalink**) 28-Jul-2006, 08:42 AM

Jillian:

Presumably you have a Products table with one row per product and a primary
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14061
key ProductID column. Base your existing form, in single form view, on this
table or better still a sorted query on the table. Then design a form in
continuous form view based on a query on the PricingHistory table sorted in
descending date order so the latest price appears first. Add a subform
control to the Products form with the PricingHistory form as its Source
object. With the main form in design view set the LinkMasterFields and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14061
LinkChildFields properties of the subform control to ProductID.

Whenever you are at a record in the main form you'll see the pricing history
records for just that product and when you enter a new row in the subform it
will automatically be given the current ProductID of the main form's current
record.

Ken Sheridan
Stafford, England

"jillian.calderon@gmail.com" wrote:

> First, I have a main form. In this form you add all of the product
> information. Everything is happy. However, now, I need to add something
> else. I need to add Pricing History to the form in a special way.
>
> Pricing History has the following fields: Pricing ID, Product ID,
> Effective Date, MRC, and NRC
> Each Product will have, at most, five Pricing History entries.
> The Pricing History is displayed as a subform within the Product form.
> Does that make sense? Each Product will have it's own unique Pricing
> History subform.
> I haven't a clue on how I should begin. Can anyone help?
>
> Thanks,
> Jillian
>
>