I have two tables. 1) ClientInfo, 2) ClientData. ClientInfo contains a ClientID field that is unique to each client. ClientData contains the same ClientID field to identify the client for a particular record of data. Each client may have many data records so there is a One to Many relationship here.
I have created a Grid (ClientInfo) with which to add Clients to the ClientInfo table. Additionally the grid has a simple search function and the ClientID field is a Link field (indecently the clientID field is auto filled in the table rules).
What I would like to do is use the Link (clientID) field to open another .a5w page containing another grid (ClientData) for adding data to the clientData table. I want this Link to auto populate the clientID field in the new grid.
I cannot rely on the folks using the database to accurately enter the ClientID that was generated in the ClientInfo grid into the ClientData grid. To maintain the integrity of the relationship this has to be automatic. I don�t want to use GridLinker as the grids already push the limits of performance in terms of the number of controls per grid.
I have seen in Help how to Link to a table that already contains the value you linked with and filter the data that populates the Grid based on that value. I cannot figure out how to use the value in the same manner and just paste it into the ClientID field of the Grid when the called page (grid) loads.
Thanks for any help.
I have created a Grid (ClientInfo) with which to add Clients to the ClientInfo table. Additionally the grid has a simple search function and the ClientID field is a Link field (indecently the clientID field is auto filled in the table rules).
What I would like to do is use the Link (clientID) field to open another .a5w page containing another grid (ClientData) for adding data to the clientData table. I want this Link to auto populate the clientID field in the new grid.
I cannot rely on the folks using the database to accurately enter the ClientID that was generated in the ClientInfo grid into the ClientData grid. To maintain the integrity of the relationship this has to be automatic. I don�t want to use GridLinker as the grids already push the limits of performance in terms of the number of controls per grid.
I have seen in Help how to Link to a table that already contains the value you linked with and filter the data that populates the Grid based on that value. I cannot figure out how to use the value in the same manner and just paste it into the ClientID field of the Grid when the called page (grid) loads.
Thanks for any help.
Comment