W
winsa
Happy New Year to you all! First day back at work and my mind is numb
already!
I have imported a batch of Insurance Certificates (Parent) that have a
number of Buildings to be Insured (Child)attached. Two separate tables, PK
of buildings consists of Certificate No. plus a Line Number. The buildings
from the file seem to be listed via size, but this is based on user judgement
I'm thinking as there is no building size field.
I thus have an issue with the numbering of the buildings:
a) how to deal with inserts and deletions that may mean reshuffling the Line
Number of each line in the affected Certificate
b) how to create some kind of rule that dictates how the buildings are
numbered. I think I can sort of use Building Category to do this.
I thought about letting the User manually change the line numbers (using
error traps if the same line number is entered on the Certificate), but I
think this poses even more problems?!?
I can't think of a way to automate it though.
Any ideas/comments/opinions will be greatly appreciated.
already!
I have imported a batch of Insurance Certificates (Parent) that have a
number of Buildings to be Insured (Child)attached. Two separate tables, PK
of buildings consists of Certificate No. plus a Line Number. The buildings
from the file seem to be listed via size, but this is based on user judgement
I'm thinking as there is no building size field.
I thus have an issue with the numbering of the buildings:
a) how to deal with inserts and deletions that may mean reshuffling the Line
Number of each line in the affected Certificate
b) how to create some kind of rule that dictates how the buildings are
numbered. I think I can sort of use Building Category to do this.
I thought about letting the User manually change the line numbers (using
error traps if the same line number is entered on the Certificate), but I
think this poses even more problems?!?
I can't think of a way to automate it though.
Any ideas/comments/opinions will be greatly appreciated.