Master detail updates

[gagsoft]

I have a master detail set Customer and Activity linked by a field called CustSeq (One to Many relationship)
I created a form with all the fields in the set. There is a browse object of the child table
on the form. I created another form called Activities. A button which runs "Open form or browse layout " action script with the "Enter new record" option. The problem is that it does not honor the master detail relationship. (It enters a new record in the activities table but not with the current Custseq number).Although when entering a new record on the browse object it enters the current master CustSeq number. I tried another method by adding the following action scripts to a button:
1. Enter new record
2. Save record.
3. Zoom to record.

But this adds a new record to the Customer table as well as the activities table.
Can anybody explain what I am doing wrong.

[Al Buchholz]

RE: Master detail updates

Peter

When the form is based on the set, the master detail relationship is known and both tables are available.

When you made a form called activities, I guessing that you made it based on the table activities - not the set. So if you open that form and add records, all it knows about is the one table - activites.

[Cheryl Lemire]

RE: Master detail updates

Peter,

Al is correct. Since you are opening a separate form to enter the activities you will need additional code to accomplish your task. I am doing something similar. I have a set based form where I show the child table in an embedded browse. My embedded browse is read only because I do not want new records entered into the child table via the embedded browse.

On my add new record button for the second form, I have taken the value from the linking id field on my set based form and assigned it to a variable. When I open my new form, I assign the variable value to the child table record. On my new form I also have a button to allow them to add new records to that current specimen since I am not allowing continuous enters. This add new record button also needs to populate the linking id field, again using the value in the variable.

If you allow the new records to be added via the embedded browse on your set based form, you do not need to populate the linking id field as it is automatic with Alpha.

Hope that helps.

Good luck.
Cheryl

[gagsoft]

RE: Master detail updates

Cheryl

I tried this approach but I am still not there.
OK... same scenario as above (Both forms based on the set).
I populated the add button with the following scripts:
1.Get value property of object (Storing it in a
variable which is globaly available )
2.Open form of Browse layout with the "Enter new record
option"
3.Set value property of field(s)this is where I get stuck.
when selecting the "Another form or browse window", the activities form is not available for selection. It says only current open windows are listed.

Would it possible for you just to provide me with a small code segment so that I can see how you achived the above.
Kind regards,
Peter

[martinwcole]

RE: Master detail updates

if both forms are based on the same set, and you are entering a record to a child table, you first have to fetch the correct parent on the 2nd form, so it adds the child to the correct parent - if you are doing it this way, then it will automatically assign the linking field to the child.

usually, though you do something like this:
create a form based on the child table only
from the main form, (based on the set,)
say the key field is "customernumber", and that field is displayed on the main form

f=form.load("childtableformname")
f.new_record()
f.customernumber.value=parentform:customernumber.value
f.show()
f.activate()

you have now begun the entry of a new record on the 2nd form, and have preentered the linking field - note though, that if you let them enter more than one record while they are there, you will have to adopt a method like Cheryl is using.

I often use different forms for viewing/editing child tables and for entering new records, and turn off navigation for the new records-form, and when they save the record, close the form and bring them back

[Stan Mathews]

RE: Master detail updates

"3.Set value property of field(s)this is where I get stuck.
when selecting the "Another form or browse window", the activities form is not available for selection. It says only current open windows are listed. " - so open the activities form before you start editing the "master" form. You can open both and minimize the activities form while you are making the action script choices. It should then be available when making your final selection.

[gagsoft]

RE: Master detail updates

Just a word of thanks to everyone that help to make this forum as vibrant and helpful as it is right no.....Thanks a million you guys.

Peter

[gagsoft]

RE: Master detail updates

Martin

I used the your code as suggested. It worked fine. But when I tried it again on another master / detail, it incremented the master "customernumber" before inserting it in the detail "customernumber" . It does not take the current "customernumber". Although the set is configured correctly as far as I know "One-to-many" and both forms are based on the set.

Many thanks

Peter