Help

[misschanda via AccessMonster.com]

I would like to link two different tables so that when information on one is
enter that information is automatically populated on different table w/
similar fields.

LA

 

[BruceM]

That's probably not a good idea since it sounds as if it would involve
redundant data. However, without knowing more about the structure of your
database and what exactly you need to do, it is difficult to provide a
specific suggestion.

 

[J_Goddard via AccessMonster.com]

Hi -

Can I ask why you would want to do that? You would then have to make sure
all updates to the information were made to both tables - unless the data is
just to "initialize" the second table and can be changed afterwards.

If the data needs to match, you can put it in only one table, and then by
linking the two tables in a query, you will have access to all the data.

John

 

[misschanda via AccessMonster.com]

I have made some cascading combo boxes (were make final selection based off
choices of combo box previous). Well boss wants to change some things around
and I need some help.

I was told from a previous entry to do follwoing:
I have a table with all raw materials this table has supplier date receieved
etc concerning that raw material. For the combo boxes I copy 3 main fields:
category, description and material and gave each of these fields there own
table. In each of the new tables I also included fields that linked the
table together so it would better me in my cascading option.

well, new raw materials have come in and have been inserted into the grand
table that host all raw material and other information like supplier and
receive date. My problem is getting that information to show on the 3 new
tables, so that new materials can be seen in the choice of the cascading
boxes. How is this done.

 

[BruceM]

Each type of information should be in its own table. A "grand table" with
information about raw material, supplier, and date received is almost
certainly not the best choice. Can a supplier sell you several types of raw
material? Can the same type of raw material come from different suppliers?
Do you want to know how much raw material you have on hand?

I would guess that you need:
A Supplier table that contains only supplier information
A Raw Materials table. Depending on your needs, it could be linked to the
Supplier table and contain information such as package size (large bag,
small bag, etc.) and price.
A Purchasing table, also linked to the Supplier table, for Purchase Order
information such as PO_Date, OrderedFrom, Material, PackageSize, Quantity,
etc.
A PurchaseDetails table, for line item information related to a particular
purchase order (if you order several items from one supplier).
You may need other tables if you purchase the same type of raw material from
different suppliers, if you need to keep track of who ordered the material,
and for whatever you do with the raw material once it is in your inventory.
The Northwinds database that ships with Access can give you some insights
into how the parts of a database relate with each other.

There is more information at this site, for one:
http://allenbrowne.com/tips.html
Under Tips for Casual Users, see especially the Table Design links. Also,
there is a link marked Links on the right side of the screen at that site,
which lists other web sites that contain design information.