I have a database already set up with ingredients, cost of each...etc.
What I would like to do on a seperate layout (or database if deemed
proper) is one of our sandwiches xyz and list out the ingerdients from
the other database:
Product Description PricePerUnit Total cost

I would like to keep the product prices updated as time moves on. (A
little background on my Filemaker experience: I have been teaching
myself how to use it very sporatically over six years. My problem is I
do not use it enough to retain any solid memory on how to eg, make an
invoice or other report which can be made and filed away never tp be
changed or when to use repeating fields or portals.)

I guess what I would like to know is how to relate (through product id)
the fields and have all the info pop up from a popup list (eg, I push
product, product list pops up, I chose product, and all of the other
fields are filled by the appropriate info automatically).

I know this is novice stuff (actually, a few years ago I was able to do
it fine), but for the life of me, I cannot get it.
Thank you for your help,
Dwight

I am using FM 8.5
--
"Did you help me out of jams as kids, or what?"
"You were just a punk, you were never really that bad."

In article <2007052412060116807- (AT) news (DOT) giganews.com>, Dwight wrote:

"ReciPIE"?!? Are these sandwiches or pies? ;o)

I'm not quite sure whether you want the prices to update existing
records or not, but the basic structure is the same. Something like:

Sandwiches Table (stores each sandwich)
Sandwich Name Text
Sandwich ID Text / Number, Unique
Total Price Calculation = Sum(Ingredients Table::Price)

Ingredients Table (stores list of ingredients for each sandwich)
Sandwich ID Text / Number
Ingredient Text
Quantity Number
LookupPrice *see below*
IngredientPrice Calculation = LookupPrice * Quantity

IngredientPrices Table (stores prices for ingredients)
Ingredient Text
CurrentPrice Number

In the Sandwiches Table you can then have a portal to contain list the
ingredients, quantity and price for each individual sandwich record.

The sandwiches ingredients are stored as separate records in the
Ingredients table.

Each record in the Ingredients Table can "look up" the price for a
single quantity from the IngredientsPrices Table. If you do not want
the sandwich prices to change as ingredient prices change, eg. a
historic record of sandwich prices, then the LookupPrice field needs to
use an Auto-enter calculation (set NOT to update itself in newer
versions of FileMaker). If you do want the prices to keep updating
themselves, eg. for printing menus, then LookupPrice should be a
Calculation field using =IngredientsPrice Tablle::CurrentPrice.

The IngredientsPrices Table stores the current price for a single
quantity of each ingredient. This needs to be updated every time a
price changes.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On 2007-05-26 20:55:45 -0400, Helpful Harry
<helpful_harry (AT) nom (DOT) de.plume.com> said:

Thank you for your help. That makes a lot of sense.
--
"Did you help me out of jams as kids, or what?"
"You were just a punk, you were never really that bad."