•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 456,598 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,454 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1840 | Replies: 2
 |
•
•
Join Date: Aug 2007
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Updating LookUp table Hi there.
I'm looking for a bit of advice.
I have a lookup table (tlkOrganisations) which has only one field (apart from the ID) and it list orgnisations. I'm using this for a field within a form so that I can use it as a lookup combo.
The advice I'm looking for is., What would be the best way of updating the lookup table. It's possible to add a new organisation to the combo field within the main form but this wont update the lookup table and invariabley wont update the combo selection.
I was thinking about a Organisations popup form to update. Does anyone have any suggestions? I want to avoid having to go to the datasheet to update.
I'm looking for a bit of advice.
I have a lookup table (tlkOrganisations) which has only one field (apart from the ID) and it list orgnisations. I'm using this for a field within a form so that I can use it as a lookup combo.
The advice I'm looking for is., What would be the best way of updating the lookup table. It's possible to add a new organisation to the combo field within the main form but this wont update the lookup table and invariabley wont update the combo selection.
I was thinking about a Organisations popup form to update. Does anyone have any suggestions? I want to avoid having to go to the datasheet to update.
Last edited by pablavo : Sep 6th, 2007 at 6:24 am.
•
•
Join Date: Sep 2007
Location: Far reaches of known space
Posts: 58
Reputation:
Rep Power: 2
Solved Threads: 4
Junior Poster in Training
you can put a button beside the drop-down thingy that says something like [update users]
this opens a form that allows you to add to the table. the [save] button you create will save the row and then close the form and then reopen the first form.
voila'! your new user is now part of the dropdown list.
ps
there is a way to do this programatically in vb, but... can you program and spot errors in logic and sytax as you type?
this opens a form that allows you to add to the table. the [save] button you create will save the row and then close the form and then reopen the first form.
voila'! your new user is now part of the dropdown list.
ps
there is a way to do this programatically in vb, but... can you program and spot errors in logic and sytax as you type?
(o) Yes, I'd like to reboot my computer now.
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Microsoft Visual C++/ODBC lookup (C++)
- Using OpenGL in Visual C++: Part I (Game Development)
- Database Table Design (Database Design)
- Lookup tables - how to perform a switch using a string (C++)
- look-up table help (PHP)
- Need direction on how start this programm (C++)
- Primary Key Issue (Visual Basic 4 / 5 / 6)
- DNS & internet explorer. (Web Browsers)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Field size: Replication ID?
- Next Thread: combo box with related records
