Jump to content
Sign in to follow this  
treds

help with mutiple fields

Recommended Posts

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

Share this post


Link to post
Share on other sites

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?"

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Hi

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

Cheers

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Thanks

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    ron n 
×

Important Information

By using this site, you agree to our Terms of Use.