APEX

Hi All,

I am an APEX newbie and have an APEX 3.2.1 application that is still being developed that is working reasonably well. The problem I am having is the following:

I have 3 interactive reports. These are defined on their respective tables, namely, clients, servers, and databases. By clicking on a client name, it shows the servers that are associated with that client. By then clicking on a server, it shows me the databases that are on that specific server. I am able to perform updates, deletes and inserts on all of these.

In order to say create a server, i click on the name of a client and it brings me to the Server Interactive report to see the associated servers. I then click a "Create a Server" link that brings me to the create a server page. The issue i am having is that I would like to have the previous value of the primary key (Client ID) passed from the Server interactive report to the form where i create a new server so that the client ID is already populated in the Create a Server form. Presently, the only way i am able to do this is by defining the client ID column on the Create a server form as a select list and displaying ALL the different clients. By selecting a client name, this list then returns the client id associated with that client name. This is a potential source of confusion for the users and it would be much better if the client ID was already in a text field that is disabled and all they have to do is fill out the other fields of the form.

I would greatly appreciate any help in this matter as I am fighting project deadlines. I have seen other examples that are similar, but i am still experiencing difficulty.

Thanks,

Tim