how to get info from spread sheet to access

[Stephanie53]

I have a database I am creating. In this database we have assembly lines. Now when they select a Dept I want it to select the dept they need. Then the next combobox would generate the list of parts there to assemble. After making the selection of part that they are to assemble that it would auto generate all the assembly parts for that primary part. Do I need to create a table for each part??

[June7]

Need a table of records that associate primary part with the subparts. Seems could all be in one table.

Maybe you need dependent (cascading) combo/list box. Review http://datapigtechnologies.com/flash...combobox2.html

What does spreadsheet have to do with this - did you mean 'table'?

[Stephanie53]

Yes i meant table...in the table is list of all the main part(s). (i.e. the Dept, the Product #, the Discription and Price (of ourse will be adding quantity box too) If one of our sales dept selects one part we need it to generate the rest of the parts assemble for our wharehouse to put together. but for our inventory and accounting dept we need to make sure that all the added assembly is selected for the one particular part done correctly. How can I create form and VBA code to autogenerate the rest with each particular part...will have to make a table for each part and its assembly and if so how to i get the VBA code that can assist me on that direction to take

[June7]

Have a table of records that associate primary part with subparts. Filter the table by Primary and will see all related subparts.

ID	Primary	Subpart
1	6732	8905
2	6732	7654
3	6732	6541
4	4321	8905
5	4321	6123
6	4321	6541

Critical question is can any part be either a primary or subpart? Manufacturing database is not an easy one. Has been discussed many times in forum. Try a forum search.

[Stephanie53]

Yes I now remember how as you mentioned it..but I amot hitting SOLVED until I see that it works...ITS A MONDAY!! Thanks!! :-)

[Stephanie53]

ok having an issue here...the primary is not a subpart. here is example of an assembly:

4773-7191		4.0" 7.5K - STANDARD SERVICE	0
4773-8190		4.0" 7.5K - SOUR SERVICE	0
	948HXXX+64WB-A		3.0" X 4.0" 160 WB
	956HXXX+64WB-A		3.5" X 4.0" 160 WB
	964HXXX+80WB-A		4.0" X 5.0" 160 WB
	4.0" FIG. 1002 X 4.0 BW		4.0" FIG. 1002 X 4.0 SCH 160 BW
	4.0" FIG. 1502 X 4.0 BW		4.0" FIG. 1502 X 4.0 BW
	4.0" FIG 1002 X 4.0 BW DOM		4.0" FIG 1002 X 4.0 SCH 160 BW DOMESTIC
	3 1/16" 10K X 4.0" BW		3 1/16" 10K X 4.0" 160 BW
	4 1/16" 10K X 4.0" BW		4 1/16" 10K X 4.0" 160 BW
	4.0" Schedule 160		4.0" Schedule 160 Per End
	F96-7		4.0" (E) (10K) Finishing Ferrule
	5.5" I.D. REFRASIL		4.0 GRADE E HOSE
	7.00" - 24 GA. INTERLOK		ARMOR FOR 4.0" GRADE E HOSE
	73610864		4.0" Schedule 160 Lifting Eye
	73610850		4.0" GRADE E SAFETY CLAMP

The first 2 is type of hoses (primary)

The rest is when they select EITHER hose that it auto fills in the rest of the assembly and places all the parts together on the quote to eventually get on order.

Now here is my delima..

I have created the break down in Excel spreadsheet. How can I get it to read on the table to show the hoses under Primary and the rest under Subparts. Do I create a different table for both? And when they select the hose will it auto fill the rest on the form?

[June7]

The table I suggested would associate each primary with its set of subparts. This could be a very large table.

Then in another table would be records for a specific assembly per customer order. This table would have order number and each related primary ID. If there are multiple 'assemblies' for each order, gets even more complicated.

Then base a report on a query that joins assembly with parts to produce a quote document.

As I said, manfacturing not an easy database to build and I have never built one, only worked with posters in forum on concepts. Have you searched the forum on this topic?

[Stephanie53]

yes and unfortunately there isnt really alot out there that does manufacturing either....ughhh