Jump to content

Moving from 1 file to another, retain recordset


Jalz
 Share

This topic is 2349 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi Guys, I have a customer file which is a just a table of data. I then subsequently have a interface file, with a reference to the customer file, however I have a locked layout where the user can find add etc data to the customer table.

The interface file has scripts, values lists etc. and is pretty locked down. I have then created a reports/exports file which is totally unlocked. I have a reference to the customer table and only the customer table is showing in the database diagram.

My question is, if the user is doing a 'complex' find in the interface file, and out of 12000 records they find 641 records. How do I pass that foundset to the reports file. I can't use the GTTR as there is not table occurrence in the reports file, really want to avoid looping through the records.

Thanks

Jalz

   

Link to comment
Share on other sites

Yes, two different files. I don't want the user to access all the business logic if the interface file, hence the separation. Wasn't sure where to post this in the forums, but I think its a layout issue, as I'm hopping from one layout to another layout, in another file. I suspect I am going to have to loop through all the records in a found set copy the ids of the records and find them on the secondary file.

Edited by Jalz
Link to comment
Share on other sites

You can use a summary "List Of" field to get a list of record IDs; and set up a global field in the target report file that points by relation to the contact ID field there; and use GTRR within the report file based on this relationship.

Link to comment
Share on other sites

This topic is 2349 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.