In my form based on the table Customers i have a combo box looking up
for the employees. The tables Employees and Customers are related in
one to many relationship, the primary key Employeeid in ther table
Employees is connected
with the key Employeid in the table Customers.
The combo box is looking up for values in the table Employees,but the
form is not based on this table, it is based on the tables Customers.
I can open the combo box and i can choose an employee, but the form
does not save
the this employee for a given customer.
How can i do it properly ?
1  1356 
Jim Stacey wrote: In my form based on the table Customers i have a combo box looking up
for the employees. The tables Employees and Customers are related in
one to many relationship, the primary key Employeeid in ther table
Employees is connected
with the key Employeid in the table Customers.
The combo box is looking up for values in the table Employees,but the
form is not based on this table, it is based on the tables Customers.
I can open the combo box and i can choose an employee, but the form
does not save
the this employee for a given customer.
How can i do it properly ?
If your form, based on the table customers, has a combo box of employees,
what is the control source (click on the data tab of the combo) for the
combo? If empty, set it to your employeeid field name contained in the
recordsource for the form. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Megan |
last post by:
Hi everybody-
I inherited a database that somehow uses a bound combo box as a record
selector. Let me give you some background. The form is based on data
from 2 tables. The first table, Person, records info about a person.
The second table, Case, records information about a person's case,
almost like a human resources database.
The primary key of the table, person, is his/ her social security
number. The primary key of the other...
|
by: Bob Darlington |
last post by:
I am using the following SQL as a RowSource for a combo box on a form.
"SELECT LAN, TenantName as , ShopNum as FROM
qTenantSelect "
The field 'ShopNum' is a text field and has a caption property set to 'Shop
Number' in the table design.
In the combo box though, I want to use 'Shop' as the heading (to save width)
as shown in the SQL above.
But the combo shows 'Shop Number' as a heading in form view.
|
by: Will |
last post by:
I have a combo box on a form which is based on table tblMachine. On that
combo box I have four columns visible MachineNumber, description, location
and type. The bound column is the MachineNumber and this is not set to 0 as
the machines have its number on which means the user should know the machine
number. My problem is if the user doesn't know the number. I have a button
which changes the row source of the combo box to order by...
|
by: Kevin |
last post by:
A couple of easy questions here hopefully. I've been working on two
different database projects which make use of multiple
forms.
1. Where's the best/recommended placement for command buttons for things
like delete, save, edit, cancel buttons - in the footer, or on the form
detail section?
2. If in the footer, how do you add them to the tab order?
|
by: Edwinah63 |
last post by:
Hi everyone,
Please let there be someone out there who can help.
I have two BOUND combo boxes on a continuous form, the second being
dependent on the first. I have no problem getting the second combo to
change depending on what values the user selects in the first box, it's
just that every time the user changes the first combobox, the second
combobox FOR EVERY RECORD goes blank.
| | |
by: fstenoughsnoopy |
last post by:
I have a customer order database and I need to pull a customers
information, ie first name, last name, address, city, state, zip,
phone, etc, into the oder table. i don't know how to go about making
this work...
|
by: Ausclad |
last post by:
How Would you implement this?
I have an existing Access application that needs to be converted to .net
I am restricted to use the existing database design.
One of the areas is a timesheet data entry screen.
The existing Access app writes to a table (tblTimesheetHours). In the data
entry screen, the fields, like employee name, job, etc are bound to combo
|
by: virtualgreek |
last post by:
Dear All,
First of all I would like to take the time to thank you all for your efforts and time spent at this wonderful forum. I have found it very helpful with numerous examples available for every level of user.
I am facing a rather weird behaviour with a combo box on a subform (Continuous form).
I have two tables. Order and Order_Details. The master form is based on the Orders tables and the details form (subform) is based on the...
|
by: gdixon |
last post by:
Greetings To All!
I am using a Access 2003 and my programing skills are of the cut and paste variety. This means begining programming skills and on a good day perhaps middle of the road intermediate. I have used some of the combo box tutorials to get me started but I have a question, how do I save a selection choice from a forms combo box into a second table where the form is recording information?
On a form called frmIncidents I have a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
