aaeros

Thank you both for your replies. After seeing both your handles numerous times in this group, I'm fairly sure that if this problem had been posted before, one of you would have heard of it! I've tried al the obvious solutions, to no avail. Furthermore, since this is only happening on the one box, I have chalked it up to some Windows anomaly and am using the other PC without a problem. I will post it on the FMI site forum and see what develops. If anyone else has had this problem, though, I'd be interested in hearing about it!

I have installed FM7 DEV on my, much used, "shop" PC, running XP Pro , without any problems at all. But, after installing it on a newer P4 box, which has givien me no trouble at all, whenever I open any fp7 file and go to the graphic table view ( FILE>DEFINE DB) the tables are there, but the words and connection lines will not appear unless I click on the table header. If I let go, the words disappear! Also, if I try to draw lines or borders in Layout mode, I cannot see them either. Nor can I seem to set their colors in the color picker box to anything!. I've uninstalled and reinstalled several time, to no avail. But, if I reinstall it on the original PC, everything works as it should. Very strange. Anyone got any suggestions?

-Queue- Your advice cleared the roadblock. Thanks. In implementing it, I assumed that you meant that if the RESULTS of the calculation: GetRepetition(field, RLN) - were numeric, I'd need to follow with & "" - were text, I'd need to add +0 After making the appropriate changes, the full automation of filling in the referenced fields took over. Although I'm not clear as to why! But now that you've made me aware of these two modifiers, I've noticed them used in other templates and am beginning to grasp how they work. Is there a book or URL you could recommend that would supplement the help files for someone at my beginning level, explaining important syntax options such as these? Thanks Again, aaeros

-Queue-, I replied to QuinTech's query before I saw your post. Please let me extend my thanks to you, also! I will definitely try your solution, and let you know tomorrow how it works for me. But if you don't mind my asking, exactly what the modifiers & "" and and + 0, for text and numbers respectively, define for the GetRepetitions calculation? TIA, aaeros

QuinTech Thanks for taking an interest! Your time is appreciated. RLN is a number, which references the line number (LN) of the item in the main invoice I need to return. I was feeling froggy, since the first part of my effort, using the default Purchase Order Template that FMv6 provides as the foundation for my Purchase Invoices DB, had gone so smoothly. So I figured I'd be able to use: GetRepetition( field , RLN ) where "field" would represent, in sequence, all the fields for one item, across any one row of the Main Invoice, referenced by the 1 to 1 rel between RLN & LN. And it does work perfectly, but only for the first item I enter in the Returns portion. Any other item has to be entered manually, or copy/pasted, field by field. I tried everything I could think of to get past this glitch. But FM has humbled me, as I'm sure it often will. But I'm having a lot of fun with it, believe me. After all the hours I spent trying to get a program called "Formtool" to work , FM has really got me enthused again, especially after seeing the fantastic examples of creativity that folks have posted on the web!

Hello, In the body of my "Invoice Form", I used a 30 row Repeating Field to contain the following data: LN - Line Number (I enter it manually, for now) SKU - or Product ID - manually entered for now, integration of Barcode Reader in the future. DESC - Short Product Description CAT - Category (Value List, I can choose CPU, HD, MB, Sound Card, etc., or edit & add.) QTY- Quantity UP - Unit Price EP - Extended Price This part of the form works fine. I then added, at the bottom of the same layout, a short, 5-line set of nearly identical repeating fields, to track items that have to be returned. In this set, I want to merely enter a number into a new field, RLN (return Line Number), which references the "LN" of the product purchased above, using: GetRepetition( field , RLN ) to fill in rest of the Returned Item's data. But I can only seem to get this to work on the FIRST line of "Returned Items", which it does, correctly. Entering an RLN on any subsequent line does nothing; I have to enter the data manually or copy/paste. Can someone help me with this? TIA