473,854 Members | 1,530 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Creating a form to pull information from a table then add to a diff table

10 New Member
Im trying to build a form that will pull numbers from a table and when the other information in the form is complete by the user and the form is saved it will write the pulled information from table 1 it will write information to table 2 without the person having to enter the numbers pulled from table 1 in a different box so it can write to table 2. Any Help Is Appreciated!!
Jan 20 '19 #1
14 1511
32,584 Recognized Expert Moderator MVP

Really very little idea what it is you're trying to describe here. It makes so little sense.

One thing I would say though is it sounds like you need a Form bound to a (updatable) Query linking both Tables together.
Jan 20 '19 #2
10 New Member
Sorry for being so vague. Iím trying to make a form to where it will pull numbers from table 1 and when the customer enter there name and some other information in the form when they click save I need it to add that information along with the number that was pulled from the table to save to table B I could have another box that gave them a number and they re-enter that number but I have a fear is them messing it up
Jan 20 '19 #3
32,584 Recognized Expert Moderator MVP
How did the idea in paragrapgh #3 strike you?
Jan 20 '19 #4
10 New Member
Im currently trying to figure that out. Im new to all of this so it might take a few tries...

incase you wondering this is what it looks like and im trying to keep them from having to re enter the number so like the numbers show up and auto write to the table because i fear of someone messing them up.
Jan 20 '19 #5
1,430 Recognized Expert Top Contributor
I agree with Neopa's first posting. I have no idea what you are trying to achieve.

So forget everything about forms and numbers, and tell us what your Db is for. Information on what data you want to enter, and what information you want to get out and what information you want to save.

Jan 21 '19 #6
10 New Member
So we own a racetrack and when drivers come to draw they click a button to get their heat and feature start number(where they start in the race) so when they click the draw button it open a form and it will show them their heat and feature start numbers then they enter their name,class,and car number and hit save but it was not saving their heat and feature numbers unless they enter them into another box that will then only save them to the correct table but Iím afraid we will have drivers enter the wrong number to try and start in front of everyone else in the race. So Iím trying to make the box that pulls the numbers from table 1 when they open the form to save the numbers to table 2 when they close and save the form
Jan 21 '19 #7
1,430 Recognized Expert Top Contributor
Good, that clarifies things a bit!

So several questions come to mind.
1) Do the same drivers appear numerous times in a season. If so, would it be sensible to save their details?

2) How are the heat and feature start numbers generated?

3) Can you show me the layout of your table(s) and relationships?

Jan 21 '19 #8
10 New Member
The drivers have complained when we have tried other systems that save their information so we have decided not to do that.

We entered the heat and feature numbers into a table at random and have a form pulling the numbers from that table

We just have a form pulling the heat and feature numbers from a table and then the driver information gets entered into another table through the form.
Jan 21 '19 #9
1,430 Recognized Expert Top Contributor
So, in actual fact, is any data being saved, or is this a one off event, and after the race, ALL data is lost?

It would seem to me to be simpler for the driver to enter their details, then use some sort of random number generator to allocate the heat and feature numbers.

If this sounds sensible, how currently are you entering those numbers into your table. What restraints are there on those numbers (Like maximum number if entries per race)?

Jan 21 '19 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

by: David Bradbury | last post by:
I currently have an iframe on a webpage into which users can insert content. They can further customise the text as I've included buttons such as Bold, Italic, Bullet point etc. This is done along the lines of <td><div class="cbtn" onClick="cmdExec('bold',idContent)" onmouseover="button_over(this);" onmouseout="button_out(this);" onmousedown="button_down(this);" onmouseup="button_up(this);"> <img hspace="1" vspace=1 align=absmiddle...
by: skubik | last post by:
I'm curious as to whether it's possible to create a Form object and populate it with form element objects, strictly in Javascript, without the need to apply the form to a document. Essentially, I want to do this: tmpFormObj = new Form(); tmpFormObj.target = document.location; // For example. tmpFormObj.method = "POST";
by: fkealty | last post by:
I'm attempting to make a small user database more efficient. I have an employee table with id numbers, last name first name title and address. Using a combo box I select the last name and have used the following to automatically fill in values on the form: =. column(2) and so on for each field on the form This works great on the form but the only entry made on the table is the "last name", everything else appears blank.
by: Ken | last post by:
I have a table I am trying to create with a unique Pk Table fields JobID---PK JobDate I would like to have the primary key be a combination of increment number starting with 001 and year and month such as 510=5 of year and 10th month Each month I would like the increment number to reset itself so november 1 it would start at 511-001 the December would be 512-001 I did this in the form using
by: Michelle A. | last post by:
I have a four page form. Pages 1-3 stores there information in a session variables. Page four is reached (a final review page) and then the information will be written to the SQL server. When I tried to enter some code in the HTML table by hand so I could get it to show up in the right place. For example I use this code in the HTML table: <td><%=sessionvar1%><%=sessionvar2%></td>
by: Burbletrack | last post by:
Hi All, Hope someone can help me... Im trying to highlight the advantages of using table variables as apposed to temp tables within single scope. My manager seems to believe that table variables are not advantageous because they reside in memory. He also seems to believe that temp tables do not use memory...
by: mbedford | last post by:
I'm buildling a form for tracking printer costs. This form will display data from several different tables pulled together by queries. formPrintCost will display: printer information from tblAssets support, maintenance, downtime and supply information and costs from tblSupport page counts from tblPrinterMeter The main control in formPrintCost is listPrinter, which is a List Box with all the printers in tblAssets. Selecting a printer...
by: Kristal Y | last post by:
Hello, I'm more of a graphic web developer than intricate coder web developer so I don't host my clients sites. Each time a client wants a form it's with a different hosting service which has a different way to use forms. Again I'm having a problem with a new site I was thrown into, and I can't seem to make their form work. So I've tried some that have worked for me in the past but it's always hit or miss and a lot of wasted time. Do you know...
by: Procman | last post by:
I'm using Office 2003 and have done some programming in Access, but not in Excel. - I have an Access DB with a form to enter all receipts and invoices. I use Excel to view the data as a Monthly/Yearly Budget Summary based on categories of the Items entered in the Access form. I am pulling the data from the Items table in Access and want Excel to SUM each category and enter the values in the worksheets by month. So the user will only need to...
by: D347HxD | last post by:
Hello, I have been working on a database and so far it's going well. I have 14 text boxes that are hooked up to a button that searched a query (which is attached to a table) for what you searched. It works perfectly... though I'd like to add one more feature to this database; and that is an add button. Where if you enter information into those same text boxes, and click the add button instead of the search button it'll add a field with all that...
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: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
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: 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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
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: 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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.