hi!

when i copy and paste fields into a portal, they show up when i am in "edit layout" mode, but when i return to view mode to enter records, the fields are no longer appear in the portal...it is simply blank. any ideas why this suddenly is glitchy? this was working fine before and has never happened before...i checked to make sure all of the boxes are within the borders of the portal, and tried to redo it but the same thing happened. I still can't figure out what I am doing wrong

• 
  

Are the fields from the same table occurrence as the portal or a TO related to the TO shown in the portal? This is the most common reason for fields not displaying.

thanks for your response. the fields are related to a table occurrence for which the portal was created. The fields are from a single table and a table occurrence was constructed for displaying the data from this table in a portal.

[edit] I'm at a loss as to why this isn't working. the portal was created the same way as the other ones. i've tried rechecking and playing around with the settings and redoing the portal, but the same things keeps happening. the fields appear in "edit layout mode" then disappear form the portal in view mode

now the same thing happened again to a previously viewable portal! I can no longer see data that has been entered in the portal for a specific record. (the portal is blank, expect in "edit layout mode") have you ever heard of this happening?

Zip your file and post it. Remove confidential data first.

thank you, the database is attached. the two portals not working properly are in the behavioral history tab and emu tab (second portal) in the tab control in "main table" layout

Database1.fp7.zip

hi! does anyone know the solution to this problem or why it's even occurring? No matter what i do, i can't seem to fix it. When i go to create more portals, the same thing keeps happening....very frustrating.

You don't have 'allow creation' on to that Behavioral relationship. It must be on for it to display anything since there are no current records in Behavioral. You need one or the other for the questions to show up in that portal.

ADDED: I must tell you that you are painting yourself into a corner with your structure where the questions are field names.

ADDED MORE: When you have multiple 'like' fields, it usually indicates they should be records in a related table and this is a prime example. How are all these fields alike? They are all questions. Most of your tables are the same - questions.

Should be table called Questions with fields for QuestionID, Type (whether Behavioral, MRI etc) and then Question (field holding the question). You then relate Patients::PatientID = Questions::QuestionID and filter the portal on each tab depending upon Type.

thanks for your response. regarding my current setup, i made individual tables for the various tests, such as MRI or PET, simply because there may well be multiple tests per patient, taken on different dates. (tables 1-4 (demographics to syndrome) will probably be merged into one table since there is a 1:1 relationship) So Patient A could have 3 MRI test results, and I wanted a way to be able to pull up all of these results for the patient. are you suggesting that I put all of these fields into one table too?