working with tables, data from one to another...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI! I have a drop down box with codes in it. Those code represent a dollar
value, which I a)need to assign to the code and b)change periodically. Then
the $ amount needs to go in to a fee's box. So, I select the code, and the
dollar amount automatically appears in the fee's box. I know this means 2
tables, so how do I code the main table to lookup the fees table, assign the
$ amount to the code in the fee's table, then take that $ amount and put it
in the fee's box in the main table. This sounds simple, but I've been beating
my head against the proverbial wall trying to do it. Any help would be
greatly appreciated. Thanx
 
still a little new myself but here it goes..someone else comment if I miss a
step..I'm not sure if you are you looking at it in table format or if you
have a form already.

If you are looking at it in table form then you could create a second table
with two columns, the code and the dollar value. you then need to create a
relationship between the two connecting the two code fields. You should click
both the enforce referential integrity box and the cascade update box. That
tells access to update your form when you update the dollar value in your
second table.
You could then use the form wizard to create a form, selecting
both the information on the main table you need and the dollar value from the
other table. It should create a form with all the controls you are looking
for.
 
I have the form for the main table already. However I am going to do what
you suggest and see if it works. Thanx
 
Thank You SOOOOOOOO much. This has been wrench from hell. Also, I posted on
3 different groups before I came here. Should have come here 1st, next time
I will.
Sean DuPont
 
Back
Top