Post Applicant Information

[Shorty]

I have two databases: Property Tenant Information and one called Prospect/Applicant . I enter the applicants information on the application in the Prospect/Applicant file, this information flows to a Tenant Scorecard and if they are approved, I want to be able to click a button and the complete information is copied or moved to the Property Tenant Information (specifically the tenant tab in the Property Tenant file).

 

I just can't seem to figure what the calculation would be or if I am needing a script to do this?

 

Any help would be appreciated

 

 

Thanks

[SlimJim]

One solution would be to have the information looked up so you will need to click a button which creates a relationship between the two files, and specifically between the two records. Maybe a prospect ID number which the button transfers from the prospect file to the property file and then once that relationship is set the tenant data can be looked up via the relationship.