A funny thing happened on the way to the forum.....
Duplicated a very complex table (kept everything except layouts).
The new table was generally the same as the old - except for the fact that 'some' field rules were 'truncated'.
ONLY A PROBLEM IN FIELD RULES.
6 fields have associated fields.
Each of these 'master' fields has 4 associated fields.
Let's call the five fields a group.
Each group was the same basic format, just different names/categories.
The fields were:
charge -- one of the 6 major categories
income
sales tax
taxable dollars
non-taxable dollars.
In the original table- under charge:lookups, values were inserted and by adding additional columns, associated values were designated for the other 4 fields.
eg.
charge = 30.00 -- column 1 in 'charge' lookup
income = 29.58 -- col 2 in same lookup
sales tax = 0.42 -- col 3 etc
txbl dlrs = 4.50 -- col 4 etc
non txbl = 25.50 -- col 5 - got the pix
Under each 'master' field (and associated fields) there are
from 5 to 10 entries in the lookup table....
30 --------
40 ---------
etc
Now: On the form....
When a lookup value is selected (or typed in) for the 'master' field; all the associated fields are immediately filled in according to the field rules.
All calculations based on the 'associated' fields are
correct and when the record is saved, all is OK.
In the duplicated table, all of the associated field values are missing from the lookup.
This is not a major problem, since I still have all the values in the original table.
My point: Is this 'loss' normal or ?????????
FYI
D
Duplicated a very complex table (kept everything except layouts).
The new table was generally the same as the old - except for the fact that 'some' field rules were 'truncated'.
ONLY A PROBLEM IN FIELD RULES.
6 fields have associated fields.
Each of these 'master' fields has 4 associated fields.
Let's call the five fields a group.
Each group was the same basic format, just different names/categories.
The fields were:
charge -- one of the 6 major categories
income
sales tax
taxable dollars
non-taxable dollars.
In the original table- under charge:lookups, values were inserted and by adding additional columns, associated values were designated for the other 4 fields.
eg.
charge = 30.00 -- column 1 in 'charge' lookup
income = 29.58 -- col 2 in same lookup
sales tax = 0.42 -- col 3 etc
txbl dlrs = 4.50 -- col 4 etc
non txbl = 25.50 -- col 5 - got the pix
Under each 'master' field (and associated fields) there are
from 5 to 10 entries in the lookup table....
30 --------
40 ---------
etc
Now: On the form....
When a lookup value is selected (or typed in) for the 'master' field; all the associated fields are immediately filled in according to the field rules.
All calculations based on the 'associated' fields are
correct and when the record is saved, all is OK.
In the duplicated table, all of the associated field values are missing from the lookup.
This is not a major problem, since I still have all the values in the original table.
My point: Is this 'loss' normal or ?????????
FYI
D
Comment