Hi,
I'm trying to create a general form with multiple subforms. The subforms contain discrete pieces of information such as Customer, Work Order, etc, while the main form is simply a front-end for the user.
In one of the subforms, I'm having a problem which is either a design or coding issue, I'm not sure which. I have a Customer table and a PhoneCustomer table so that I can link multiple phone numbers to a particular Customer. I want to be able to set the preferred number for each customer, preferably with the first contact number given as the default preference.
The fields I'm have in the two tables include:
Customer
CustomerID
FirstName
LastName
Company
PhoneCustomer
PhoneCustomerID
Person - The customer (i.e. CustomerID) the record is tied to)
PhoneNumber
PhoneType - What's the purpose of the phone, i.e. home/cell/work
PreferredNumber - Is this the preferred number for the Customer? (TRUE/FALSE)
Essentially, my issue boils down to one of the following:
1. Is there a way that I can create a radio button on a form (for each single record) that has all the radio buttons for a given CustomerID linked?
2. Should I change my design? Would PreferredNumber be best served within the Customer table?
This is being done in Access 2000, although I'm thinking about upgrading to Access 2007. I'm not very familiar with VBA, although I know I should start learning more on this.
Your comments are appreciated.
1  2117 
Well, the solution is quite simple. You create a field in the customer table that has the PhoneCustomer ID number stored there. Then you would simply create a Combobox and have it display the customers phone numbers based the customer ID. This way you can select the ONE phone number that is the preferred number for the customer.
If you need code examples, please let me know, and I would be more than happy to explain in detail.
Hope that helps,
Joe P.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: entoone |
last post by:
I am able to make a selection of information when entering a record, with
radio buttons giving the option of yes, or no.
Which stores their answer as yes, or no in the database. I then have an
update record page that reads information in the database, and presently it
will not retrieve the previously selected option from the database. I have
tried all sorts of if else statements, and can't get anything to work. I
want the previously...
|
by: M.E. |
last post by:
Hi
I have 4 radio buttons. each button to determine which page to go to. But
before page open user enters username in a text box. So when submitted, Page
opens relevant to that user displaying selected page.
I have no idea how to achieve this, and a good example would be greatly
appreciated.
|
by: Suzanne |
last post by:
Hi,
I have a form which our clients can fill in with their
personal details. As part of the information we store
there is a section - areas of interest - this is a number
of radio buttons.
I need to be able to send to a stored procedure the areas
that the client has selected so these can be stored in the
database.
|
by: Jim Quast |
last post by:
I have an ASP page and a CREGReports002.vbs file coded to export data to
excel. I do this by building variables in a stored procedure. The ASP page
has text boxes, list boxes, and radio buttons. I also placed two buttons on
the form. One submits the form to redirect to the Crystal Web Viewer
(genCREGReports.ASP). The other one executes VB code in a vbs document that
spawns some more code to run a stored procedure with the values from...
|
by: Jared |
last post by:
Radio Button or Check Box and Event Procedures
I need to insert either radio buttons or check boxes onto my form. I'm
not sure which to use, or if there are other options. I am using the
buttons to: if one is clicked, its corresponding information will
become available on another document, if it's not clicked no
information will be provided. If multiple buttons are clicked their
information will available on the same document.
I'm not...
| | |
by: Ken Varn |
last post by:
This is probably a simple question, but I am new to this so bear with me.
I have a ASP.NET form that has a checkbox and a 2 radio buttons. When the
checkbox is checked, the 2 radio buttons are enabled using javascript. When
the checkbox is unchecked, the 2 radio button are disabled with javascript.
Here is the problem that I am seeing. When I submit the form with the radio
buttons disabled, the form returns with both radio buttons...
|
by: James P. |
last post by:
Help,
I need to display radio buttons on a form. The data is from SQL
table: each row in each table is displayed as a radio button. I have
multiple SQL tables so I understand I need to put them each in a
GroupBox. All the examples I saw from the books or from the web show
me how to add static radio buttons at design, or dynamically at run
time but with fixed radio buttons (like from an array).
I need to create radio buttons based...
|
by: Arsalan Ahmad |
last post by:
Hi,
May be I am a newbie, or may be i dont have that much insight in following
systems ..i.e. why i have some confusions as below:
In many websites, when search is performed on some keywords (not only
including google which perform general search but other sites which perform
seach on a particular type of item in their database) then many search
results are obtained (for example more than 100 or even more than 1000) but
only limited...
|
by: Shane |
last post by:
I think that I found a bug in the Radio Button, and I wanted to give
everybody a "Heads Up". I spent three days doing trial and error until
I found a work around.
I created a user control with a text box and two radio buttons. The
text box has the TabStop = True, and both radio buttons have TabStop =
False. The radio buttons are set to false so that a Tab (or captured
Enter) may tab to the next control. The appropriate radio button is...
|
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: 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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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: 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: 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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
