Help with populating fields for a new record

4 New Member

I have two tables created and want to link two forms created from these tables so that specific fields are populated once one field is selected, but not all fields being populated, with a new record being saved into one of the tables.

Tables:

1. StaticInfo
contains fields:
1) Department
2) DepartmentNumbe r
3) AccountExecutiv e
and 7 yes/no fields

2. Data
contains fields:
1) Department
2) DepartmentNumbe r
3) AccountExecutiv e
7 yes/no fields
and 6 Memo Entry fields

The memo entry fields are the ones in which the data will be entered. The fields in the StaticInfo Table are fields that will not be changed often or maybe not at all. I want to make it faster/easier for the user to enter info by not having to enter all of that information in StaticInfo each time they open this form to create a new record. What I would prefer would be a drop-down done by Department, so that when the department is selected, all of the fields in the form are populated except for those 6 memo forms that new to be filled in for a new record (not just retrieving an old record and saving over it). This is why I have created the StaticInfo table. The new records will be held in the data table. Also, redundency or anything like that is not an issue and I just want to complete the task at hand, it's a small database and will not be slowed by any redundency.

Currently, I have a Data form created and a StaticInfo Sub Form in this Data form. As of now, I can select department from the drop down and all fields populate in the StaticInfo Sub Form. However, I don't know how to link the two so that I can enter that memo information and have it all save on a new record in the Data table.

I realize that this is a lot of information and I may not have explained it the best, I'll update my explaination if anyone requires further information. It actually seems like quite a simple thing to do, but I'm finding it difficult. I'm not even sure if I'm thinking about it the right way or if there may be a better solution. Any help, comments, suggestions would be greatly appreciated.
Thanks

Mar 5 '08 #1

Subscribe Reply

1824

mgstlucia

New Member

Hi, I did you get the field to automatically populate? I have been trying to do this with a form when a customer name is choosen, to poplulate the address, city, state, zip. Thanks

Mar 5 '08 #2

mgstlucia

New Member

No need to reply, I got it to work

Mar 5 '08 #3

Similar topics

482

help with data transformations with outer join?

by: Preston Landers | last post by:

Hello all. I am trying to write a query that "just" switches some data around so it is shown in a slightly different format. I am already able to do what I want in Oracle 8i, but I am having trouble making it work in SQL Server 2000. I am not a database newbie, but I can't seem to figure this one out so I am turning to the newsgroup. I am thinking that some of the SQL Gurus out there have done this very thing a thousand times before...

Microsoft SQL Server

4101

Populating multiple textboxes with multiple records for update page

by: Drew | last post by:

I have a db table like the following, UID, int auto-increment RegNo Person Relation YearsKnown Now here is some sample data from this table,

ASP / Active Server Pages

2359

Need help displaying text data for foriegn Key in form

by: Susan Bricker | last post by:

Greetings. I am having trouble populating text data that represents data in my table. Here's the setup: There is a People Table (name, address, phone, ...) peopleID = autonumber key There is a Judge Table (information about judges) judgeID = autonumber key

Microsoft Access / VBA

1647

Populating one field in a table with one to many relation

by: hasanainf | last post by:

Hi, I have a main table named tblCrPurchase2 with following fields CrPurchase2ID - key field InvoiceDate InvoiceNumber PF1 I have a child table called tblCrPurchase2Detail (this is the many side of the table) with following fields

Microsoft Access / VBA

508

Help with DLookup

by: Don Sealer | last post by:

I've written this expression for a DLookup function. It works almost alright. What I'm trying to do is type in a description and the ID field (number) populates automatically. It works almost as I've said. It doesn't populate until I go to a new record. Then if I go back to the record the number is in the field. Instead of populating immediately it waits until I've created a new record. Am I making sense with this description. Here's...

Microsoft Access / VBA

1897

My Brain Hurts - Help

by: Siv | last post by:

Hi, If I run the following: strSQL = "Select * FROM Clients;" da = New OleDb.OleDbDataAdapter(strSQL, Conn) 'Create data adapter cb = New OleDb.OleDbCommandBuilder(da) 'Create command builder using the datadapter dt = New Data.DataTable da.Fill(dt) 'pour in the data using the adapter

Visual Basic .NET

20116

onclick event for table row record to form field

by: prosad | last post by:

hello, Just solved a problem using Javascript onclick, can click on any cell in a dynamic table and it will pass the innerText object value to my form text field. parts of code given below: <script type="text/javascript"> function select_cell(obj) { document.getElementById('complaint').value = obj.innerText; document.getElementById('selected_form'); }

Javascript

1356

Help with populating fields for new record

by: daverskully | last post by:

Microsoft Access / VBA

1772

Filter Code Help

by: Desitech | last post by:

I am not sure how to go about this. Any help would be greatly appreciated. Here is what I am trying to do: I have a table with records. I want to associate each record with multiple associations. For Example: record 1 A-12316 belongs to KI2001, KI4000 and KI9200. record 2 A-06542 belongs to KI2001 and KI4000. record 3 A-11523 belongs to KI4000

Microsoft Access / VBA

10153

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

10093

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

7500

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6740

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5381

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5511

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4053

transfer the data from one system to another through ip address

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

C# / C Sharp

3654

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2880

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General