FileMaker Pro troubles

Thread View: comp.sys.mac.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by 89611628s Tue, 26 Jan 1993 11:38

#663

Author: 89611628s
Date: Tue, 26 Jan 1993 11:38

16 lines
920 bytes

I have a problem in my FileMakerPro 2.0 Database:

I have one Database which contains products, another which contains orders, and
a third which contains files in which i calculate the cost derivated from the
products and orders.

PRICE = PRODUCT * QTY ORDERED

If I wanna calculate the price, do I have to copy every product and qty
ordered in my database, or is there a function which makes direct reference to
another database ?

Thanx for ur support.

Ralph Schwegler, Students of Economics at SG University of Economics,
Switzerland

Re: FileMaker Pro troubles

#667

Author: Brian Hughes
Date: Tue, 26 Jan 1993 14:37

24 lines
1729 bytes

89611628s@sgcl1.unisg.ch writes:

>I have one Database which contains products, another which contains
>orders, and a third which contains files in which i calculate the cost
>derivated from the products and orders.

    Why have you chosen to use 3 files for this? Couldn't you just
calculate the costs within the file that contains the orders? This could
possibly make your life a little easier.

>If I wanna calculate the price, do I have to copy every product and qty
>ordered in my database, or is there a function which makes direct
>reference to another database ?

    Actually, what you want to use are lookup fields. These fields
perform the function you are looking for, but they are not live direct
links between the files. If you have some prices in the file already
calculated, and then that price changes in the product file (which is
where I'm assuming you have the product prices stored) you will have to
tell the lookup fields in the other file that use that product's price
to go and get the current price.

-Hades
--

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads