I have hit a brick wall or have a brain freeze.

I need to populate certain fields in one record with information from multiple records in a related database. The records are related by a single ID number. But... In multiple occurences of the record in the related database I only need information from records where a certain field containes a particular #. clear as mud?

I think you are looking for a portal to show a one to many relationship. Then a filtered portal would then limit the data to the records with a specific value.

Attached is a list of students and grades in many classes. Then I filtered a portal to show only classes where the students received an "a".

Hope this is the right direction.

filterportal_Copy.fp7.zip

gartmorris: No, that is not at all clear. When asking for free help it is best to be sure you have provided your helpers with plenty of descriptive information to work with. Don't make people play guessing games. Provide an example file and/or provide more detail about what you are trying to do.

Also, explain why you need information from 1 table moved to another table. This is called redundant data, and the transfer is often unnecessary. But, if it is really needed, you must be able to say (more or less) how and when this data transfer is supposed to happen. Because it will not happen automatically; it needs either something (specific) to trigger an auto-enter (in the receiving table), or it must be set via a script, which also needs a mechanism to make it happen. Hence redundant data is something to be avoided whenever possible.