Linking field

[bob9145]

When I create a new record in say the customer table I am trying to simultaneously create a new record in a related table. During this twinned or two step record creation I am trying to take the primary key from the customer table and insert it in the related table.

I can pass data using the onpageredirect feature to another dialog or grid component but the auto incremented primary key value is not created at this point. I tried this in a view but the same situation exists.
At the point of entry the primary key does not yet exist so it can't yet be inserted in the related table.

Is there a technique to easily accomplish this? I need to generate the customer record and then create the related record with the primary key from the first record. I am trying to allow the user to do this when he registers. This will be invisible to the user but the result will be that he is entered into two or more linked tables.

Tks
Bob

"If at first you don't succeed try, try and try again!

[peteconway]

Re: Linking field

Bob, you don't need to do any of that - Alpha has many ways of doing things - there is a lot of information about that is no longer required so stick with only recent release notes, there are many things Alpha V10.5+ does for you easily.

If you have a table that has a field you want to use to crate a relationship with another field in another table, just ensure both fields are the same type and length, you can then simply create grid the holds the parent table, and a grid that holds the child (related table), you must select to include the fields that are to create the relationship in the grid (then hide them) - you must do this for both grids - you then open the parent grid and insert the child grid as a row expander, you create a filter between the two by matching the fields in the row expander builder, you must use the link option. When you run the parent grid and click the row expander + the related record will be empty - enter some data, save and you are done, the relationship is created by Alpha.

[bob9145]

Re: Linking field

Thanks Pete

[NicholasWieland]

Re: Linking field

Pete,

I am trying to do the same thing there is an issue doing this for a grid, whether
1-Tabular Type
2-Form Columnar
3-Stacked Columnar

It does not work for "ADD ONLY RECORDS"

If you have update/insert then yes but add only no.
If so I would really like to know how to and what options I need checked or not! Been playing with this to long and have to move on to a different method if can not figure out thanks.
:o

[bob9145]

Re: Linking field

Nic,
All the video an emphasis in V10 is on linked content.
There is not much on how to initially link the content.

I am approaching this in a way that allows the linking to occur as the user enrolls in different aspects of the web app.

I tried the row expander within an add only grid template and was also unsuccessful.

Maybe Pete or some one else has additional info.
Tks

[NicholasWieland]

Re: Linking field

Bob,

I am playing right now with a few different ways and will report back, but I do not think it is possible to do with an new add transaction.

Will update, soon.

[NicholasWieland]

Re: Linking field

Bob,

I just found out from the top you can not do this on a "NEW RECORD".

So I am going to do this. I just posted something in another post.
I have created a grid that has no visible fields but plenty under the hood (hidden) they are prefilled. I have a document_type field which will be set to say "N" for new record. Once I hit start the process it will auto increment post all prefilled information and I will redirect to another page that has the grid parent - child records but I will filter on the parent for document_type="N" which will for me pull up the record and then I also have an autofill on the child grid which will also work.

Not seeing a downside on this method yet?

[bob9145]

Re: Linking field

Thanks Nic,
I will examine your technique. Maybe the top has some other suggestions as well.

What is the other post?

[bob9145]

Re: Linking field

It seems to me that the trick is saving the parent record and then retrieving it back to the browser. Then passing the data to the linked grid.

The problem seems to be that the parent record must be created and saved first. There is no auto incremented field to pass to the linked grid until this is complete. It can be done with the row expander when a parent already exists. In the case of a single record there is no parent yet to inherit from.

Can a domino affect be created, where the parent record is saved then retrieved and then the linked field is passed to the child field and it is then committed with the linking field filled.

Tks

[bob9145]

Re: Linking field

Is there a way to generate the auto incremented field when the browser opens with the add only grid.

The DBF default table browse in the control panel generates the auto increment number as soon as one of the other fields in the browse gains focus. How can this be brought through to the web Browser?

If this can be accomplished than the Auto incremented field would be available to pass to another child grid or dialog component.

If some of the Alpha legends could weigh in on this it would be appreciated.

Tks

If at first you don't succeed try, try and try again!

[bob9145]

Re: Linking field

One more shot. Can this be done with a Guid? Wouldn't that be generated before the record is committed? I could then pass the guid to the linked grid as the linking field.

[NicholasWieland]

Re: Linking field

Bob,

Can not do on an add grid.

tbl = table.open("[PathAlias.ADB_Path]\recieptsheader")
tbl.enter_begin()
tbl.Growerid = currentform.controls.Growerid.value
tbl.Bol = currentform.controls.BOL.value
tbl.Usdf = currentform.Controls.Usdf.value
tbl.Time = now()
session.__protected__receipt = tbl.Id -this is an autoincrement field.

I have done this before and then write the session onaftervalidate but have not test this on mysql this was on DBF's

[bob9145]

Re: Linking field

Thanks Nic,
I will check it out.