Making an offer.

[Arnaldo]

Hi to all.

I have these tables:

- agenda:

- addresses;

- price_list.

Agenda is to used to make an offer for renting items listed in price_list to a customer in addresses. Thus, I made a relation agenda -> addresses by means of memorizing the unique_key of addresses in agenda choosing from a drop-down list showing name + location from addresses.

Now the problem. I'd like to input the offer having:

- a drop-down showing the items in price_list;

- show the price from price list;

- make calculations to obtain a total amount, etc.

I made multiple fields (I know they're obsolete, but as an old RPG programmer I'm used to build up arrays and manage them) of item's unique key and price, by the relation agenda::item_description -> price_list::item_description (description is unique).

Results: price_list::description goes into agenda::description[n] but in agenda::price always just the first price_list::price is shown even if I choose the, let's say, 4th price_list::item_description (which has a different price). Of course, agenda::price is defined as calculated by means of agenda::price = price_list::price.

So I tried by defining agenda::price by means of Let function with Get(ActiveRepetition) or Get(CalculatedRepetition) - sorry, a bad translation from Italian - to have the number of the multiple field I was in to add the value of price_list::price to agenda::price[number] (what does syntax require in this place [] or ()?). Result: no syntax error exiting the field definition, but nothing happens.

Tried with a portal, but wasn't able to have a drop-down list appearing in agenda::item_description (field setting: drop-down list, list made of price_list::item_description).

The more: what I would like to save in agenda is only the unique key of the price_list::item_description and price_list::price at the moment of offer being made.

Of course, I could define in agenda:

- 50 times item_description;

- 50 times price;

but I do not like this "waste" of time, and, suppose, disk space.

And more: how can I save values I want from a portal to another table?

Hope problem exposure is clear.

Thanks in advance.

Arnaldo

[Dr. Evil]

I'm not real clear on what your problem is. Your post is data over load! lol

Here is a quick sample file for you to look at. I may have missed the issue completely but we can start here.

sample.fp7.zip