473,231 Members | 1,621 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Help with populating fields for new record

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) DepartmentNumber
3) AccountExecutive
and 7 yes/no fields

2. Data
contains fields:
1) Department
2) DepartmentNumber
3) AccountExecutive
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
0 1334

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

Similar topics

0
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...
7
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,
9
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...
2
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...
6
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...
28
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) ...
4
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: ...
2
by: daverskully | last post by:
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...
9
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. ...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.