Hi

I am trying to bring in 3 different fields from 1 file into another file

One field is a product code drop down

I want to be able to select the product code and have the other fields come into to the layout

can bring one in but not 3 any ideas on the best way to bring all 3 fields

I'd like to confirm what you mean when you say "file." Do you mean a separate FM file or do you mean a table within the same FM file?

Sounds like you are setting up an invoice system (wanting product codes in a drop down). If you give us the big picture, we can offer more support of how to accomplish the details. What is the layout's purpose? is it a purchase order? invoice? What relationships have you established between "files/tables?"

Hi Bcooney

Yes its another FM file

it is a invoicing system of sorts!

fields that I would like to bring into from another fm file are

1 is the product code [which should be a drop down]

2 is a description of the product

3 is the various things needed for that product

in the new file by selecting 1 product code it brings in the other 2 fields

thx

Hi

I have attached the file could someone have a look a the relationships

Cheers

You've got a lot of learning to do! You might wish to read up on some basic FM stuff. Here's a sample file for you.

SampleFile.zip

Thanks

I have created with portals already but Ive seen it done another way using scripts and relationships