Cetin, Hello

Per your remarks, I went to my DE and added my offices.dbf table to the data environment of both my offices.scx and office_assignment.scx.

That helped a lot! I am no longer getting an error message. When I run my offices.scx and click my cmd button (assign contact), the office_assignment form pops up.


However, I do not have things set quite right, b/c the following things are happening.


#1. When the office_assignment form pops up, it doesn't have the officeid number automatically placed into the orderid textbox.

I can manually type it in, and that appears to work fine. But, I have to be missing something for it not to automatically reflect the officeid number of the offices form.

#2. I entered some contact assignments for a few offices to see if each office only reflected the correct officeid (which I manually entered), and they reflected each office, not the specific office. It pulled up the office I was currently on first (which is what I want), but I could keep on scrolling through the office_assignments form and see all the other assignment I made for the other records (which is not what I want). I just want to see the assignments for the current record I am on......... not all the assignments I have entered for each office.

I hope this isn't confusing.


So, I guess my questions are:

1. How do I get the officeid ti automatically generate in my office_assignment form?

2. How can I configure this so that only the current office I am on is called up when I add a contact to that office, in my office_assignments form?


Just to be thorough, here is the code I have set in place.

Init event of my office_assignment form

lparameters tcOfficeID
=seek(tcOfficeID,"offices","nofficeid")


In the click event of the cmd button (assign contact) of my offices form, I have:

DO FORM office_assignment WITH offices.nofficeid


Once again, thanks for any help.

Jason