Init cond question parent field reference

[Tony Saladino]

Hi,

First, the intro.

I'm using Alpha 5, and have a set where the primary table is an employee table. The first link table is a join table(joining employeeID, jobID, stationID) that has an auto-increment field called workID and uses the employeeID as the key. There is a link off the work join table to a work time table using the workID as the key.

The idea is that the employee brings up the work form and is able to click on his name in a browse. This links with the work table, and shows all the jobs he is assigned to in an embedded browse on tab 1.

He can then go to tab 2 which has a browse showing him the his work time table for that job. He clicks the "sign in" button, and it puts the current time in the "start time" field. He clicks the "sign out" button and it puts the current time in the "end time" field. He can clock in and out as many times as he wants until he answers a dialog that he's done, and then the status for the job is changed to complete.

Now that the intro is done, here's the question.

The first time the employee goes to the second tab, no records exist in the table for that workID. How do I determine what the current workId is from the parent table so that I can create a new record based on that workID?

After I have a record for that workId, the form will have filtered for the workID, and I can just do a fetch on the first record to see what value is in the workId field. I just don't know how to get the workId for that first record.

Tony

[Dan Blank]

RE: Init cond question parent field reference

Hi Tony,

What you want to do can be done in a few different ways. Perhaps a good demo or teaching tool is from Tom Cone Jr. in the Code Archive. You can find his demo HERE

Tom has provided a nice download to study and learn from.

Hope this helps.

Dan

Dan Blank Databases, Inc.

[Tony Saladino]

RE: Init cond question parent field reference

Thank you Dan. I'll take a look at it.

[Tony Saladino]

RE: Init cond question parent field reference

Hi Dan,

I've tried running a very simple test to see if I could use the code you pointed me to. It seems that I may be missing something.

I have one form based on the set. On the first tab of a tab object is a browse object based on the table "work" (BROWSE1). On the second tab is a browse object based on the table "work_time" (BROWSE2). The set has "work_time" linked to "work" using the key field "Work_id".

I ran the following very simple code from the OnPush Event to see if I could pull the "Work_id" field from parent table "work" and place it in the child table "work_time" using forms as Tom Cone Jr. suggested.


if is_object("BROWSE2") then
ui_msg_box("Info", "Object BROWSE2 exists.", UI_OK)
BROWSE2.new_record()
BROWSE2:Work_id.value = parentform:Work_id.value
end if

The BROWSE2 object did exist. I then got an error message saying that parentform:Work_id did not exist.

Any suggestions?

[Dan Blank]

RE: Init cond question parent field reference

Hi Tony,

It is a little hard to follow without an example.

Two suggestions:

One, zip up a sample of your work and post it on the message board.

Two, you may want to go to my web site and look at an article titled "Getting more than one parent field into a Child Table".

Thanks,

Dan

Dan Blank Databases, Inc.

[Tony Saladino]

RE: Init cond question parent field reference

Dan,

Thank you for pointing me to your web page. The lookupc function would work great for additional fields, but I need the first key in the example. How would I get the Invoice_No passed down to the child table.

I'm including a sample program. I'm sorry it took so long, but I had to strip out all the non-pertinent info and and some text for understanding.

Tony

[Dan Blank]

RE: Init cond question parent field reference

Hi Tony,

Well I looked at your app. Couple of things.

It isn't good practice to name a set with the same name as a table. You don't need to set the default expression for an auto-increment field. On the form you needed to add code for the OnFetch event and the OnActivate events. You also needed to add another form for the data entry to take place. Even if it just opens only to be needed to close.

Any way take a look at your form based on my set. It should help and get you going.

Dan

Dan Blank Databases, Inc.

[Tony Saladino]

RE: Init cond question parent field reference

Thanks Dan,

I'll make the programming practice changes you recommended.

I was somewhat confused about how things were completed until I saw the all important OnInit event for the Time_entry form.

I guess it would have been too easy to have BROWSE2:Work_id.VALUE = BROWSE1:Work_id.VALUE
when both are in context according to the Object Explorer.

Thanks again, and hopefully I'll be able come up to speed without too many more questions.

Do you sleep?

Tony

[Dan Blank]

RE: Init cond question parent field reference

Hi Tony,

Yep, I sleep. However, I think you'll find Tom Cone, Jr is the one who never seems to sleep.

Don't worry about asking questions. That is what make this board a great learning tool. You won't find anything like this anywhere else! (at least not to my knowledge)

Have Fun!!

Dan

Dan Blank Databases, Inc.

[Tony Saladino]

RE: Init cond question parent field reference

Dan,

Since this board seems so easy going about questions, compared to some of the other boards I've been on, I may start asking some questions a little quicker than I normally do.

I've got about three weeks to finish a major project for a customer, of which the clock in form was a small part.

Next step, ensure the employee can't clock in if he hasn't clocked out from the previous job.

Have a good day Dan.