Multiple Fields from Value List

[Matt Leach]

I'm creating an orders database to replace the software we currently use and we are trying to keep everything as close to the same as possible for the users as well as ease of importing data.

In the old software, we had the option for value lists, but were able to populate multiple fields based on one list

For example, we have a field for:

line item

Qty

Price

We have a value list on the line item field that is setup as:

product;qty;price

the ; would be interpreted as a tab and put that data in the next field. For example:

valuelist would have widget;1;9.99

that would populate the line item field with widget, the qty field with 1 and the price field with 9.99.

Is such a thing possible with file maker's value lists?

I know that there are other better ways of entering products but the bosses would like to keep it this way if possible as it will also make importing data from our other software much easier.

The only way i can see to do this now would be to create a value list of the product names only, default the qty to one and as for the price field, a bunch of if statements basically scripted as if product = X, price will be 9.99 and so on.

Thanks in advance!

[Vaughan]

Don't go there. Put each piece of information in its own field.

[Matt Leach]

Don't go there as in it is not possible to do this or don't go there as in dont do the if statements?