472,345 Members | 1,530 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Help with populating fields for a 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.


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.
Mar 5 '08 #1
2 1700
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
No need to reply, I got it to work
Mar 5 '08 #3

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

Similar topics

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...
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,
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,...
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...
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...
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...
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...
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...
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...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

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.