AnsweredAssumed Answered

How to create a record in a layout with 2 related tables?

Question asked by st3lla on Nov 3, 2010
Latest reply on Nov 9, 2010 by st3lla


How to create a record in a layout with 2 related tables?


Hello everybody!

I am working on a project which keeps history of women who visit their gynecologist. I have a layout, called "Main", which shows demographics of a specific woman (name, address, etc) and a summary of results of her medical examination.

In this layout there is a button "New Cycle" that goes to the Layout "Cycle Details", which shows the demographics (table "woman") again and info about the cycle of the woman which means the procedure of IVF (table "cycle"). Here is the thing, one woman can have many cycles. When I press "New Cycle", I can make a record of cycle for a specific woman whose name is the same as in the Main layout. When I go back to the Main layout I have a portal with the fields of table "cycle" which has to get updated. However, if I want to add a new cycle then the button "New Cycle" from Layout "Cycle Details" allows me only to edit the previous record. If I press new record, then the couple demographics disappear and I have to make a totally new record; so the relationship between woman and cycle tables gets lost.

So far, the table cycle (child-table) has a field "WomanID" which is related to the field "WomanID" of table woman (parent-table).

Is there any way to update the table cycle of Cycle Details layout without changing the couple demographics? In that way I would like in the Main layout to see my portal get updated with more than just one cycle record.

Any help would be much appreciated! Thanks in advance!