C
Cole Davidson
Hello. I am working with a database comparing the insured value for a certain
building and the actual value of the building. I have one table
(PolicyHolderInfo) in which I have two fields, PolicyNumber and PolicyHolder.
I have another table (BuildingInfo) in which I have PolicyNumber,
BuildingName, BuildingType, InsuredValue, and EstimatedValue. Currently I
have the two PolicyNumber fields tied together so once I input it into the
PolicyHolderInfo table, it will appear in a drop down menu in BuildingInfo.
However, I have thousands of buildings to input, and hundreds of policy
holders to input so looking through the list for the correct number takes
quite a bit of time. Is there anyway that I can set the Default Value of
PolicyNumber in BuildingInfo Table to the most recently entered PolicyNumber
in PolicyHolderInfo? And if not, what about the most recently entered
PolicyNumber in the previous BuildingInfo record?
building and the actual value of the building. I have one table
(PolicyHolderInfo) in which I have two fields, PolicyNumber and PolicyHolder.
I have another table (BuildingInfo) in which I have PolicyNumber,
BuildingName, BuildingType, InsuredValue, and EstimatedValue. Currently I
have the two PolicyNumber fields tied together so once I input it into the
PolicyHolderInfo table, it will appear in a drop down menu in BuildingInfo.
However, I have thousands of buildings to input, and hundreds of policy
holders to input so looking through the list for the correct number takes
quite a bit of time. Is there anyway that I can set the Default Value of
PolicyNumber in BuildingInfo Table to the most recently entered PolicyNumber
in PolicyHolderInfo? And if not, what about the most recently entered
PolicyNumber in the previous BuildingInfo record?