Not able to enter the next line item in a invoice
Just on 1 invoice I can't seem to enter the next line item.
All other invoices there are no problems so I can enter in as many as needed
Any ideas as to what is going on?
Not without knowing a lot more about your database. ;-)
Is this from a FileMaker template? If so, which one?
What version of FileMaker?
If not from a template, do you have the typical arrangement of an Invoices layout with a portal to LineItems?
If so, what relationship details did you set up for the relationship needed for this portal?
This usually happens if one of the key fields on the child side is no longer indexable. FM won't warn you if you do something to make it unstored (such as include a global or related field). :-)
I was able to go 1 line below and it allowed me to enter information...but for some reason this one line will not allow me to enter any data.
Its a mystery...Pic attached
Pic with arrow.
Not enough information Jay. We need to see the table occurrence names that these fields represent and what fields (and calculations if any) that the relationship is based upon. Screen shot of your graph clearly showing only this relationship will help as well.
UPDATED: It DOES seem strange - it's not a normal error. If the relationship is indeed fine then it might be a corrupt file or a broken index. It would help to see the file (upload somewhere since this website won't take attachments). :^)
Exactly how are you locked out of that portal row? Can you put the cursor in the field but can't enter data or are you completely blocked for even entering the field? Could there be OnObjectEnter triggers on the fields or the portal? If so, check the scripts to see if they are doing something. It looks like you have a record there in the portal, but that the fields visible in the portal row are empty or at least do not contain visible characters.
I can click into the field and my cursor isblinking but when I type it doesn't show anything nor does the cursor move as I am typing.
I can click below that particular line as shown in the jpeg ....and everything works just fine...very weird.
Check for script triggers. OnObjectKeystroke can be used to perform a script that cancels out your keystrokes.
Pull up the records shown in the portal on a layout based on the portal's table. Try to find that record with the blank fields and see if you can edit the fields on this other layout.
i think found the line in lineitem table and it a had a "?" in all fields.
Ah, this is a known issue where an index or two in your file has become corrupted. If you are using FileMaker 11 or newer use the Recover Command with the advanced recovery options to recover the file without making any other changes to your file. (Use "copy blocks as is".) This method for rebuilding indexes BTW, is a trick I learned from a Post by LaRetta.
For More Information see: Phantom Record, damaged file message, Recover can't detect a problem
This is one of many acknowledged bugs that can be found in the Known Bug List thread here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: https://www.dropbox.com/s/jt09b82i0xijbu3/FMP%20Bugs.zip
If I remember correctly, that thread lists several methods for re-indexing. One of the other methods should work. The simplest to describe is to save a copy of your file with the Clone option so that it has no records, then import all your data into all your tables from your first file. This also rebuilds all the indexes in your file. (There are ways to rebuild the indexes associated with just one field, but then you have to select the correct field to re-index.)
What I know is found in the bug report that I made and for which you can find links in my earlier post. Have yet to hear if it occurs in FileMaker 12...
Retrieving data ...