G$ Posted October 15, 2007 Share Posted October 15, 2007 I'm stuck here... I have a portal of quotes and need to copy / paste the quote number into another table that holds the lines. I can get it (via script) to go to the quote number field, then go into quote lines table and create a new line and paste the quote number. That way they show up in the portal (linked via relationship). I've read in here that using the clipboard isn't a good practice so I've been trying to change my ways and implement the variables... How do I paste a variable into a new record? Easy question right? TIA! G$ Link to comment Share on other sites More sharing options...
aldipalo Posted October 15, 2007 Share Posted October 15, 2007 If you have a relationship between "Lines" table" and "Quotes" table then you should not have a problem displaying that data without any scripts or Copy/Paste functions. Set relationship Quotes table::QuoteID = Lines table::fk_QuoteID That is assuming Quote as Parent table and Lines as Child table. Set your layout set up to Quotes as the main table and the portal to Lines table. I believe this should solve your problem. hth Link to comment Share on other sites More sharing options...
G$ Posted October 15, 2007 Author Share Posted October 15, 2007 Allow me to clarify: I have a relationship: quotes and quote_lines. quote_lines is in the portal of quotes. They link via quote_number. To get them to show up, each record of quote_lines must have the quote_number in it's record. Hence why I need to copy it from quote and paste it into quote_line's record. I can set variable and open quote_lines, but can't get the variable ($Quote_number) to paste into the field. Link to comment Share on other sites More sharing options...
Raybaudi Posted October 15, 2007 Share Posted October 15, 2007 To get them to show up, each record of quote_lines must have the quote_number in it's record. This operation is automatically done by FileMaker, if you set the relationship to allow the creation of new records. Link to comment Share on other sites More sharing options...
G$ Posted October 15, 2007 Author Share Posted October 15, 2007 Nice! Solves that problem... but it doesn't help in another area... If I were to make an icon to "go to that line". It would grab an id and switch over to Quote_lines and find it. How would I accomplish that? Link to comment Share on other sites More sharing options...
Raybaudi Posted October 15, 2007 Share Posted October 15, 2007 If the icon is a button inside the portal row, all you need is the script step: "go to related record". Link to comment Share on other sites More sharing options...
G$ Posted October 15, 2007 Author Share Posted October 15, 2007 You da man! Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6172 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now