Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / August 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sean DuPont - 11 Aug 2006 19:19 GMT
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
InternRyan - 11 Aug 2006 22:16 GMT
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.

> 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
[quoted text clipped - 5 lines]
> my head against the proverbial wall trying to do it. Any help would be
> greatly appreciated. Thanx
Sean DuPont - 11 Aug 2006 22:39 GMT
I have the form for the main table already. However I am going to do what
you suggest and see if it works.   Thanx
Sean DuPont - 12 Aug 2006 01:23 GMT
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

>  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
[quoted text clipped - 20 lines]
> > my head against the proverbial wall trying to do it. Any help would be
> > greatly appreciated. Thanx
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.