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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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