Problems Writing Value of Key Field to Child Table

[cpgood]

I have a dialog component that has two tables in a one-to-one link. The linking field is an auto increment field in the parent table. Data is being written to the child table. But a value of ZERO is being written to the linking field of the child table. Consequently the corresponding record in the parent table is not linked to the child table. The linking field in the parent table is being properly auto incremented.

Does anyone know how to get the Key Field of the child table written to?

Thank you,
CP Good

[GGandhi]

Re: Problems Writing Value of Key Field to Child Table

take a look at your table definition and data binding if they are good then it should automatically update both tables.
if still in doubt post back the table structures someone can identify the defect, if any.

[cpgood]

Re: Problems Writing Value of Key Field to Child Table

Thank you for your reply. The issue appears to be with the Key Value being an AutoIncrement field. I have run a test where I have linked the tables on a field whose default value is generated by the api_uuidcreate() function. When I use this field to link the tables it works and not only is data written to the child table (this was not a problem before, data has always been written to the child table) but the key field in the child table was also updated with the linking value from the parent table (this has been the problem when using an AutoIncrement field from the parent table as a linking field).

I would like to use the AutoIncrement field as a linking field and I feel that I should be able to do so. But I am unable to figure out how to get this to work.

Thank you,
CP Good

[GGandhi]

Re: Problems Writing Value of Key Field to Child Table

would you please post table structure you want?
I think this is the scenario
table a
id int auto increment
rest of the fields
table b
id int autoincrement
rest of the fields
fk_key int derived from parent table is this correct?

[cpgood]

Re: Problems Writing Value of Key Field to Child Table

Hi,

Thank you for continuing to work with me on this. I believe you may have the Table B field rules incorrect. Here is the structure of the Parent and Child tables:

Parent:
User_ID, N, 10,0 autoincrement
User, C, 30
PW, C, 30

Child:
User_ID, N, 10,0
User_First_Name
User_Last_Name

The Child table has "NO" field rules. These are DBF tables. In the dialog component table definitions the Parent and Child are linked on the User_ID field. The primary key for each table is User_ID. Data is saved to the Child table but the User_ID field always contains ZERO (not NULL). The User_ID field in the Parent table is properly autoincrementing.

For instance, I just entered a record and the Parent.User_id=1632 the Child.User_id=0.

Thank you,
CP Good

[GGandhi]

Re: Problems Writing Value of Key Field to Child Table

this won't work. you need connecting linking field in the parent to the child other than the primary key of the parent and the child table primary key also should be auto increment.
parent
user_id, n, 10,0 auto increment
user, c, 30
pw, c, 30
linking_field to the child n, 10,0 (link to primary_key)

child
user_id, n 10,0 auto increment
user_last_name c, 30
user_first_name c,30

[GGandhi]

Re: Problems Writing Value of Key Field to Child Table

on the other hand if you must follow what you have, the ux will not be able to do but you can do by writing a short code after insertion.
after insertion get the primary key then insert into the child table yourself.
if you are not able to figure this out post back I will show you how.

[GGandhi]

Re: Problems Writing Value of Key Field to Child Table

here is the screencast, take a look:
http://screencast.com/t/ydi3c0uAZVUJ

[bustamorg]

Re: Problems Writing Value of Key Field to Child Table

Hi Govindan,

I love that script and it works great if you are only submitting to one table. What if you are submitting data to both tables, is there a way with that script to overwrite the previous entry in the user_id field of the user2 tables after the submit has been completed?

[GGandhi]

Re: Problems Writing Value of Key Field to Child Table

Hi Govindan,

.... What if you are submitting data to both tables, is there a way with that script to overwrite the previous entry in the user_id field of the user2 tables after the submit has been completed?

why?

[bustamorg]

Re: Problems Writing Value of Key Field to Child Table

Because in my tables there is the customer table with the PK of cust_ID, and then I have a complaints table that I have the cust_ID in it as a foreign key and that is how I am trying to link the tables together. When I use that script, since that field is already populated it moves that number down and starts a new row and puts the value there. They are being populated by the dialog and are updating the tables simultaneously. If there is a better way of linking the tables I would love to know it has been driving me crazy for a few days now.

[GGandhi]

Re: Problems Writing Value of Key Field to Child Table

you should not use that script in your case. please go back read the entire thread, this is done an unnatural way to accommodate original post.
in your case just list both tables in a dialog it will update properly. if still not able to do, post back your tables I will show you how.

[bustamorg]

Re: Problems Writing Value of Key Field to Child Table

Great thanks because I can not figure it out. Here are my tables the customer table is the primary table. I am trying at this point o get the cust_id into the complaint table without having to do it manually.

[GGandhi]

Re: Problems Writing Value of Key Field to Child Table

http://screencast.com/t/rETHZJ0ick
take a look

[bustamorg]

Re: Problems Writing Value of Key Field to Child Table

Thank you so very much Govindan, it looks as though I was making this out to be a lo harder than it needed to be. I really appreciate he time that you have taken to help me through this issue.