option group & subform

[hogan]

I have a parts & service database for our dealership. I have a form view in
datasheet format which includes

part name
part number
sale price
units sold
extended cost
discount

The discount would be determined by whether the sale was an internal or
inhouse sale or if it is retail. I would like to set the discount by an
option group but I can not figure out how to handle this with the datasheet
format. The datasheet is a subform and I was wondering if I could include the
option group in the main form. Any suggestions.

Thanks

 

[John W. Vinson/MVP]

I would like to set the discount by an
option group but I can not figure out how to handle this with the datasheet
format.

AFAIK you can't.

The datasheet is a subform and I was wondering if I could include the
option group in the main form.

Only if the discount applies to the order as a whole - the mainform's
recordsource - rather than to an individual line in the subform.

Any suggestions.

Use a Continuous Form (which does allow option groups) rather than a
Datasheet (which doesn't); or use a Combo Box rather than an option
group.

 

[hogan]

John,

The dicsount would apply to the complete order. Specifically how would I go
about this.
Thanks

Only if the discount applies to the order as a whole - the mainform's

 

[John W. Vinson/MVP]

John,

The dicsount would apply to the complete order. Specifically how would I go
about this.
Thanks

It sounds like the discount field should be in the mainform's
recordsource table, then, not in the subform. What's the structure of
your tables? Where is this field?

 

[hogan]

John,

I have a parts transactions table:

Transaction ID - auto #
transaction date
product - lookup (from Parts table)
unit price
units sold
discount

I have a query called parts transaction query and it includes calculations
to determine sale price, extended price. I also have fields in the query to
calculate "inhouse cost" and retail cost. Is there a way to select "inhouse"
or "retail" in a list box and then the appropriate cost would be displayed.

Thanks

 

[John W. Vinson/MVP]

John,

I have a parts transactions table:

Transaction ID - auto #
transaction date
product - lookup (from Parts table)
unit price
units sold
discount

I have a query called parts transaction query and it includes calculations
to determine sale price, extended price. I also have fields in the query to
calculate "inhouse cost" and retail cost. Is there a way to select "inhouse"
or "retail" in a list box and then the appropriate cost would be displayed.

That doesn't answer my question, Hogan. What's the recordsource of the
mainform? of the subform? Does a discount apply to an individual
transaction, or does it apply to the order as a whole? Does your
Product table have a unit price field? If so, how do you fill in the
Transaction unit price field?