Okay, this question will likely appear laughably obvious to many of you but I would be grateful if someone could help me out.
I have a database with a main table (TBL_Main) that requires a Customer Name and Customer Number (p-key). I am linking to an external database/table (tblCustomerData) that already has the same information within it.
On my main form I want to have the "Customer Name" field as a drop down that fills from the external table (tblCustomerData). That part is easy (and already accomplished). Here is where I am having trouble: I want the "Customer Number" field to auto-fill based upon the "Customer Name" I choose in the drop-down box.
So, if I have the following entries in the external table: [Customer Name : Customer Number], [Jason : 0001] [Jack : 0002], [Joe : 0003], [John : 0004], etc., when I choose "John" in the "Customer Name" drop down the "Customer Number" field auto-fills with "0004". Nothing is being created here, just pulling already existing information from the external table to populate multiple fields in my database. This also does not need to be a "snap shot in time". If info cahnges in the external database it is okay for it to follow suit in my database.
Thanks in advance for any help that can be offered!
I have a database with a main table (TBL_Main) that requires a Customer Name and Customer Number (p-key). I am linking to an external database/table (tblCustomerData) that already has the same information within it.
On my main form I want to have the "Customer Name" field as a drop down that fills from the external table (tblCustomerData). That part is easy (and already accomplished). Here is where I am having trouble: I want the "Customer Number" field to auto-fill based upon the "Customer Name" I choose in the drop-down box.
So, if I have the following entries in the external table: [Customer Name : Customer Number], [Jason : 0001] [Jack : 0002], [Joe : 0003], [John : 0004], etc., when I choose "John" in the "Customer Name" drop down the "Customer Number" field auto-fills with "0004". Nothing is being created here, just pulling already existing information from the external table to populate multiple fields in my database. This also does not need to be a "snap shot in time". If info cahnges in the external database it is okay for it to follow suit in my database.
Thanks in advance for any help that can be offered!