Create new record

[cpbjr]

this seems like it should be so easy, but after buying $100 worth of records and spending 3+ hours i can't figure this out. i want to create a new record in table #2 when a certain yes/no (yes) is satisfied in table #1.

so far i have

If [table#1::fieldX = "yes"]

End If

i have no idea how to compelte this and any help would be appreciated.

thanks.

[cpbjr]

this seems like it should be so easy, but after buying $100 worth of records and spending 3+ hours i can't figure this out. i want to create a new record in table #2 when a certain yes/no (yes) is satisfied in table #1.

so far i have

If [table#1::fieldX = "yes"]

End If

i have no idea how to compelte this and any help would be appreciated.

thanks.

[cpbjr]

this seems like it should be so easy, but after buying $100 worth of records and spending 3+ hours i can't figure this out. i want to create a new record in table #2 when a certain yes/no (yes) is satisfied in table #1.

so far i have

If [table#1::fieldX = "yes"]

End If

i have no idea how to compelte this and any help would be appreciated.

thanks.

[aaa]

Create script in table2 which creats new record. Then in table1 with field where you make the fieldx="Yes" join a script which enters you to this field, pauses and after putting data performs external "New record" script from second table.

[aaa]

Create script in table2 which creats new record. Then in table1 with field where you make the fieldx="Yes" join a script which enters you to this field, pauses and after putting data performs external "New record" script from second table.

[aaa]

Create script in table2 which creats new record. Then in table1 with field where you make the fieldx="Yes" join a script which enters you to this field, pauses and after putting data performs external "New record" script from second table.

[dkemme]

If your need is a new record in table2 that is related to table1 in a 1:1 relationship, another option is to create a relationship of table1 to table2 with allowing creation of records in table2. then after your if... statement, put a set field (table1_table2::table2field,"something"). When you perform the setfield, if no record in table2 already meets the relationship criteria, you will create a new record in table2.

[dkemme]

If your need is a new record in table2 that is related to table1 in a 1:1 relationship, another option is to create a relationship of table1 to table2 with allowing creation of records in table2. then after your if... statement, put a set field (table1_table2::table2field,"something"). When you perform the setfield, if no record in table2 already meets the relationship criteria, you will create a new record in table2.

[dkemme]

If your need is a new record in table2 that is related to table1 in a 1:1 relationship, another option is to create a relationship of table1 to table2 with allowing creation of records in table2. then after your if... statement, put a set field (table1_table2::table2field,"something"). When you perform the setfield, if no record in table2 already meets the relationship criteria, you will create a new record in table2.