Hello, i seem to have soem trouble on my on going project.
I am doing this on a shop, and to make and order with the calculated fields i have created a query, however how do i make sure when making the order that when i enter details such as the customer ID, and staff ID, that they exisit in the tables.
i have put the table "Customer Order", into a form but would like the database to checck that the entered Staff_ID from the table "Staff" and "Cu_ID" from Customer, exist, and therefore not to carry the order out as they do not exist
7  1487  Rabbit 12,516
Recognized Expert Moderator MVP
Hello, i seem to have soem trouble on my on going project.
I am doing this on a shop, and to make and order with the calculated fields i have created a query, however how do i make sure when making the order that when i enter details such as the customer ID, and staff ID, that they exisit in the tables.
i have put the table "Customer Order", into a form but would like the database to checck that the entered Staff_ID from the table "Staff" and "Cu_ID" from Customer, exist, and therefore not to carry the order out as they do not exist
You could have them select the Customer ID and Staff ID from a combo box whose values are limited to the list.
You could have them select the Customer ID and Staff ID from a combo box whose values are limited to the list.
how do you do this?
is it in the queryt of form. i tried both but do not know what to do
thank you for you help, i am really greateful
Rabbit 12,516
Recognized Expert Moderator MVP
You do it in the properties of the combo box on the form.
In the properties is an option to limit the choices to the list.
The Row Source of the combo box is the list. The Row Source can be a table, query, or a list of values that you type in.
You do it in the properties of the combo box on the form.
In the properties is an option to limit the choices to the list.
The Row Source of the combo box is the list. The Row Source can be a table, query, or a list of values that you type in.
thank you this worked. however i could not do this for the field "Prod_Name", on the query. this came form the "Products" table.
is this because ots not a proimary key
Rabbit 12,516
Recognized Expert Moderator MVP
It doesn't have to be a primary key.
When you say it doesn't work, what do you mean?
The values don't appear?
The values aren't limited to the list?
It doesn't have to be a primary key.
When you say it doesn't work, what do you mean?
The values don't appear?
The values aren't limited to the list?
Its ok i figured it out, i used a query builder instead.
thank yopu so much for your help you have been great, and i really appreciate the help give.
thank you
Rabbit 12,516
Recognized Expert Moderator MVP
Not a problem, glad to be of help.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Thierry S. |
last post by:
Hello.
I would to test the existence of a variable before to use it (like
isset($myVar) in PHP).
I try using "if myVar: ", but there is the error meesage (naturally):
"NameError: name 'myVar'...
|
by: Matt |
last post by:
Hello,
I see other references in this newsgroup saying that the only standard
C++ way to test for file existence is some variant of my code below;
can someone please confirm...or offer...
|
by: Julia Jin |
last post by:
Hi, there,
I have a list of elements. Each time when a new data comes in, I need
to check if the new data exists in the list. If not exists, I need to
insert the new data into the list.
If I...
|
by: Johnny Google |
last post by:
Here is an example of the type of data from a file I will have:
Apple,4322,3435,4653,6543,4652
Banana,6934,5423,6753,6531
Carrot,3454,4534,3434,1111,9120,5453
Cheese,4411,5522,6622,6641
The...
|
by: Jonathan Woods |
last post by:
How can I check data existence in other table(Transaction Table) in
crystal report?
for example.
Prodouct Table : ProdID
Sale Table : SaleTxID, ProdID
What I would like to do is in...
| | |
by: DC Gringo |
last post by:
How do I test for existence of a file in the file system:
If FileExists(myVariable & ".pdf") = True
pnlMyPanel.Visible = True
End If
--
_____
DC G
|
by: Brian P. Hammer |
last post by:
I have data from multiple SQL tables, some of the tables will only have one
row, while others multiple rows. I load a bunch of data from the various
tables and add them to a third party grid. With...
|
by: Motoma |
last post by:
This article is cross posted from my personal blog. You can find the original article, in all its splendor, at http://motomastyle.com/creating-a-mysql-data-abstraction-layer-in-php/.
Introduction:...
|
by: Merlin1857 |
last post by:
Its great producing data for users to look at in your web pages and generally that is sufficient for their needs but sometimes you may want to supply your user with the data in a form they can...
|
by: =?Utf-8?B?SnVsaWEgQg==?= |
last post by:
Hi, I wonder if anyone can help?
I've got a web form (intranet), .net version 1.1. I've got a sub that
populates a datatable in a dataset, dependent on a dropdown field selection.
This works...
|
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,...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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...
|
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...
|
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...
| | |
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 ...
| |
