M
marcello
Hi,
I've a little problem. I have two tables :
- one with records with an id, a name and a field interest rate. Two
records can have same id.
- one table listing unique_id as primary key and a field named
discrepancies. I want to list in that last field all interest rate
discrepancies spotted for records having same id.
For instance I have 2 records id id_a, one named name_1 with interest rate
1%, one named name_2 with interest rate 2%. In my 2nd table I have one unique
id id_a listing "name_1 interest rate 1% name_2 interest rate 2%". That
field would have been blank if interest rate would have been the same.
I designed a form with 2 fields unique_id and discrepancies, and a sub-form
listing all records with same id than the unique_id. I want my field
discrepancies being updated on line, as soon as I've updated one interest
rate. I know a little Visual Basic, but I can not make it on my own. Could
you please halp me.
Rds
Marco
I've a little problem. I have two tables :
- one with records with an id, a name and a field interest rate. Two
records can have same id.
- one table listing unique_id as primary key and a field named
discrepancies. I want to list in that last field all interest rate
discrepancies spotted for records having same id.
For instance I have 2 records id id_a, one named name_1 with interest rate
1%, one named name_2 with interest rate 2%. In my 2nd table I have one unique
id id_a listing "name_1 interest rate 1% name_2 interest rate 2%". That
field would have been blank if interest rate would have been the same.
I designed a form with 2 fields unique_id and discrepancies, and a sub-form
listing all records with same id than the unique_id. I want my field
discrepancies being updated on line, as soon as I've updated one interest
rate. I know a little Visual Basic, but I can not make it on my own. Could
you please halp me.
Rds
Marco