Addressing specific records in a field to use in a report

[Ben Rudder]

Hi

I need to create a report which has the following things:

1. Take weights entered using a form divided into
shellfish species
2. Total the weights of each species
3. Multiply the total specie weight by a price that
changes each week
I have parts 1 and 2 done, but its part 3 where my
problem lies.

The only way I have found to change the price through a
form is to have two tables. one with category ID and
Species fields, and the other one with category ID and
Price field. This is linked by a one to one relationship

(After giving you the background i finally get to my
point!)

In the report i need to get an exact record from the
price field. I guess its something to do with the
category ID field (Which uses unique numbers) so a
shellfish species can only have one price.

Hope this isn't too confusing

Thanks for any help

Ben Rudder

 

[Bryan Martin]

C-Inline

Hi

I need to create a report which has the following things:

1. Take weights entered using a form divided into
shellfish species
2. Total the weights of each species
3. Multiply the total specie weight by a price that
changes each week
I have parts 1 and 2 done, but its part 3 where my
problem lies.

The only way I have found to change the price through a
form is to have two tables. one with category ID and
Species fields, and the other one with category ID and
Price field. This is linked by a one to one relationship

Couldn't you just use the detail format section in the codebehind to have it
lookup and fill in the price to species. If im missing something let me
know.