dchaley369

Passing pre-assigned ID and other ID's into another table

Discussion created by dchaley369 on Dec 29, 2017
Latest reply on Dec 30, 2017 by dchaley369

I have eight thousand pre-assigned property id fields that are joined to 2 more pre-assigned id fields.

 

For example, P-1, the property number id carries with it both  L-1, the lot number id and the N-1 neighborhood number id.

 

All of these are pre-entered and will not change nor can a user delete or alter them, they are forever as they are.

 

The issue is, I need to create a record on another table that will be assigned multiple Property id’s and have the L id’s and S id’s automatically fill in.

 

When I use a portal it creates a new record for the properties which of course I do not want.

 

What can I do besides scripting by variables in order to pull the Property P-1 and its L-1, N-1 info into the deeds as I create a new deed?

 

Any help will be greatly appreciated.

 

Many Thanks

Outcomes