Autopopulating Fields

[finneyz]

I have a relationship from one table to another. If one item is entered into one field, I would like it to auto-populate it into another field. But there are several more fields I would like to be autopopulated.

EX
Table_1

item no, hull no, description

Table_2
item no, hull no, description..

I want to enter data into table 1 and have it auto populate into table 2. How is this to be done

 

[plog]

The question isn't how, but why? This isn't the way a relational database is to operate. One of a databases purposes is to eliminate redundant data: You are trying to create it.

Could you tel us more about what the database is for, what you hope to accomplish by having redundant data and possibly the actual table names.

 

[finneyz]

in some of the other tables there will be additional information. IE
Master list
material list.
items from material list will be imported into master list
then what warehousing will be needing

 

[plog]

Why must data be populated from Table 1 to Table 2. What are their names? What is the purpose of each table?

 

[finneyz]

Purpose is to copy data from one table to another.
We will have the master list of materials
and the material list that is always added to it.

Materials will be added to material list
It will propagate to the master list.


I just am looking and have been trying and fumbling around with relationships, queries, to make it so that if one item is typed into a field, it COPIES it to the other fields in the other databases. Thats what I need to happen.

 

[finneyz]

Im not really looking for a dropdown box or combo box.
I want it to be updated without that. without user interaction

 

[plog]

Purpose is to copy data from one table to another.

That's not a purpose that's an action. Without a clear understanding of what the ultimate goal of this database is, I am not going to be able to help you. The way you discuss it leads me to believe you are not going about it in the right manner. Data shouldn't have to be copied into new tables, this is not the way a database should function.

 

[finneyz]

I understand what you are saying... why two of the same databases. I am creating about 4-7 different types of databases. They will populate into one database.
1 might contain information such has items
another contain information such as location
another might contain information such as qty
and another containing information such as model no

all of these I want to be populated into a single database.
I hope that will clear things up for us

 

[jdraw]

I think you should tell us in 5 or 6 lines WHAT exactly you are trying to do.
From your earlier posts, you seem to be trying to use database software without designing your tables and relationships, and possibly without understanding database concepts.

plog has tried to get information, while trying to give you good advice.

We can only help you once we understand your situation, your experience and WHAT you are trying to do. So for us to help you you're going to have to tell us something.

You might wish to read this short article on relational database concepts and principles.
http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452

 

[finneyz]

We are trying to develop a database that contains a entire list of all items.. LOM

A person will type into DB_1. This will contain items such as item no, qty, drawing no, description of the item. That will also go into the LOM, all items included.

DB_2 will be Location, model no, materials needed. And again will populate into the LOM

I hope that will clear things up for everyone

 

[jdraw]

I think you are confusing Database with Table.

Do you honestly feel that your last post would satisfy some general statement of requirements for a database project?

What is your "Business"? Are you facing an issue or opportunity that suggests some form of automation?

Here is a link to a process for designing a database. It may help in putting some facts together and setting up some tables and relationships.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

There are a number of free data models at
http://www.databaseanswers.org/data_models/index.htm

Some of these may give you ideas for a design.


Good luck.

 

[finneyz]

Hello JDRAW and PLOG

Thank you again for your assistance. Due to a COMMUNICATION error from our co-workers we have resolved the problem. It is more or less a population table that I was after. After the table is populated, it should either print it to a query or a report. Hopefully that shouldn't be a problem.

I am just having an issue getting my table to be populated.
(again, as information is typed in, there is a master list of materials) (sigh)
There may be multiple tables for one building, IE, as in floors. x3 or so tables

The form based on the section_no, with an event procedure.
this is the event procedure code
Option Compare Database

Private Sub CBOSECTIONID_Change()
Me.TXTContract_No.Value = Me.CBOSECTIONID.Column(1)
Me.TXTContract_No.Value = Me.CBOSECTIONID.Column(2)
End Sub

I believe my issues are now, getting the proper columns together, getting it to populate the description, the u/m, drawingno.. I hope that this helps in getting our sorts out.

 

[Pat Hartman]

I've read this thread several times and still don't understand the purpose of copying data from one table to another and each person has tried to convince you it is wrong to do this. Perhaps if you posted a picture of your schema (make sure we can see all the columns in each table as well as the relationships), your design would be more apparent. In general, it feels like you are making tables that look like spreadsheets and when you say things like "There may be multiple tables for one building, IE, as in floors. x3 or so tables", it is clear that your schema is not normalized. It a relational database it would be extreeeeeeeeemely rare to have tables with identical formats.