Related records not visible in portal

[jwren]

I can enter data into a portal and it creates related records, however the data entered into the portal then disappears! The related files remain. I cannot see my related records from the portal.

Parent table: Volunteers

Related table: Volunteer notes

Any help would be appreciated. I am trying to get this database completed.

[jwren]

Oops - I have solved my problem - in my haste I neglected to check my match fields (auto enter serial number) definitions matched! Sure pays to double check each step.

One had defaulted to a date field from the last field created.

Feel a bit silly really! All OK now.

I will be more diligent in the future before I cry for help.

[Vaughan]

You need to have a "primary key" field in Volunteers that is an auto-entered serial number. do not allow the field to be modified. Call this, say, VolID. Make it a number field.

Make a number field in the Notes table, call it VolID too. This is the "remote key" field. Do not put an auto-enter serial number on this field.

In your relationship graph, link the Volunteers and Notes TOs tigether with the VolID fields.

[J__]

so you are saying that you actually type data into the portal fields and then once you commit the record in the portal they disappear from the view/layout?

Is the data in the underlying table? volunteer notes? If it is, then

is the foreign key in the volunteer notes table the same as the volunteer tables primary key? they should be. Might be fk field is not getting set.

take a look at the data in a table view for those two tables I think that will give you a hint as to what is going on.

hope this helps,

sincerely,

J__