I'm getting very frustrated with trying to get this working. I've tried following other suggestions in this forum but must be mucking up on one vital peice.
From a choice in a combo box I want other values filled in on a form.
Can someone link me to a small, easy to follow example? I think I've got the query part sussed but fall down on the form side.Cheers:(
I apologize for asking yet another question about autolookup but I have poured of Pat Hartman's example and all the posts in this forum and still can't seem to make it work. I have attached my db. I want to type in the asset number and autofill the rest of the form. Can someone please look at this and tell me what I am doing wrong. Thank you very much.
View 2 Replies View RelatedI am building a purchase order database that derives its subcontractor information from a separate table.
I want to be able to drop down a list for the subcontractors and once selected, the entire subcon area will be populated.
Another section of this PO is the project name, etc., which is a similar scenario, which has to be populated in the same manner.
Word file shows the structure of the PO.
Any help would be greatly appreciated!
jan.bodlund@shaw.ca
I'm trying to establish a ticket/citation database for a college security office at which i work at. I have two tables, table 1 includes the ticket information (date of ticket, citation number, *tag #, amount etc.), table 2 includes Repeted offenders information such as (name, address, city, zip, phone number, student ID# etc.).
I would like to have a table or query(preferably table) which automatically matches tag#'s to student information as soon as a new ticket is entered, *if the student information is available.
Thanks a lot in advance
I was just wondering if anyone knows how to sort of mask an ID as text. For example in this assignment I am doing at university I have a field named Flower ID which is a number. However, instead of displayign that number in forms and tables I want it to display its equivalent Species and Variety of flower. Is there anyway to fix this? Thanks for your help.
View 2 Replies View RelatedHi there!
It's been almost 10 years since I've done any work with databases, so I'm really REALLY rusty and I barely remember how to do anything. I was wondering if you guys could help me out with a question I have in making a form.
I have 2 tables. The first table has a list of names and ID's. There exist some duplicate names, as some people are associated with more than one ID.
And there are two fields to the ID. One is Called the Client Code, and the other is the Client Division.
So the 1st table, in datasheet view, is basically:
# | Last Name | First Name | Client Code | Client Division
The second table is a list of addresses based on Client Code and Client Division:
# | Client Code | Client Division | Address 1 | Address 2 | Etc
----
What I'm trying to do is the following:
I'm trying to create a form such that as I'm typing in a last name, it does autolookup and auto filling. I may have multiple people with the Last name of Smith, so then it dynamically creates a dropdown box with all possible unique first names associated with the last name Smith. And after I choose/type in the first name, I get to two more dynamically created drop-down boxes that list all possible Client Codes and Client Divisions associated with this name. After choosing that, I figure it's a simple autolookup to populate the address fields.
Does anyone have any insight on how I can get this done? Another piece of functionality that I'm trying to work into this is that if the name doesn't exist or if there's a new Client Code and Client Division or a new address, the data gets automatically added to the respective tables.
Does anything of what I wrote make any sense?
Any help would be greatly appreciated.
thanks
Imants
I am trying to pull information from 2 seperate tables and store that information in a 3rd table. I need to autofill information from both tables when I select the information from the field that joins them. Then that information needs to be saved in the 3rd table. I have to store this "duplicate" copy of the informaion becuase one table's inforamtion changes quite frequently and I needs to be able to find historical data. Here is a simplified version of my tables for example.
Products: ProductID (KEY), ProductDescription
Quote: ShipID (KEY), ProdcutID(KEY), Price (changes per ShipTo)
ProdutsOrdered: OrderID (KEY), ShipID, ProductID (KEY), ProductDescription, Price
Again, all information has to be stored in ProductsOrdered because things like Quote.Price can change frequently.
Another important feature is I have to beable to add records with what ever method I use. This Is being done in a sub form so that many products can be placed on an order form. I can get the tables to combine in a way that will allow me to view the information, but not add to it.
I have an autolookup that changes the numbers 2, 4 and 6 into P, M, and D so they look easier for my purpose. However, when I use a select query to find the max number for each criteria it shows a number not the letter. Do lookups stop working when you apply maths or can i change this.
View 6 Replies View Related