I have created a quote form for my business but am having trouble getting 1
function to work.

I have a field called item and a field called price, quantity, total..

The math works fine but I would like to select the item from a drop down box
and have that selection

automatically fill in the price that goes with that item.


Right now I have to select the item and manually fill in the price, This is
getting old fast with 100's of items.

Any help would be greatly appreciated, I am sure it is something simple, I
was successful in access so I assume

it is achievable in FM



Thanks
Jeff

On Mar 6, 6:54 pm, "Jeff" <jeff.bo... (AT) comcast (DOT) net> wrote:
It's not clear how your database is already set up. How are you
selecting the item currently? It sounds like you're not typing it in
manually, so where does it come from? Is there another table which
stores the items?

If you were to start if from scratch, you would need to make another
table named Items with at least three fields: ItemName, ItemPrice, and
ItemID. Set ItemID to be an Auto-Enter serial number field, so each
ItemID is the unique identifying number for that item. Add an ItemID
field to your line items table or whatever table you're currently
entering the quantity in. Then you relate the Items table to the
LineItems table via that field. In the field definition for Price,
you can set an Auto-Enter Lookup, using the value from your related
Items table.

G

That was what I am trying to do, and that part works but when I have several
lines For items in the same form all lines duplicate each others results.

Item Price

Item Price

Item Price

When I Fill In the 1st they all come back with the same results, If I change
the second They all change to match.

Thanks Jeff

"Grip" <grip (AT) cybermesa (DOT) com> wrote

Again I don't know how your database is set up, but I'm guessing
you're using pre-built form that relies on repeating fields instead of
a separate table for line items. You need a third table, for line
items. If that's not the case, you need to explain your current
databse structure better.

G

On Mar 7, 12:48 am, "Jeff" <jeff.bo... (AT) comcast (DOT) net> wrote:

And if you are trying to link to seperate field (getting sdeperate results)
you need separate TableOccurances. One for each unque field you are trying
to relate to. Obviously tou are getting the same result over and over agian
because you are using the same relation each time.

Ursus


"Grip" <grip (AT) cybermesa (DOT) com> schreef in bericht
news:1173279287.210713.284260 (AT) v33g2000cwv (DOT) googlegroups.com...