If you can please help me

[pedjvak]

Hi every body
just for your information : at first my work is piping(montage 2 lines by welding to each others)

so


I have 2 table named "material" & "Welding"
I want to create a table by mixing of 2 above table according the below term:
for each record of welding table I need to record of material table (for example when we join 2 line by welding each line have a specific material and code
but that 2 line join after welding as a one record in welding table)
how I can do this ? plz help me.

[recyan]

tblMaterials
MaterialID	MaterialName
1	ABCD
2	EFGH
3	IJKL
4	MNOP
tblWelding1
WeldingID	MaterialID1	MaterialID2
1	1	4
2	2	3
OR
tblWelding2
WeldingID	Material_ID
1	1
1	4
2	2
2	3

What is required , based on above or is it something totally different ?

Thanks

[pedjvak]

I show you in above pic what happened in my work and I need to recording it to my Data base

[pedjvak]

I want finally have some record like above in another (new) table

[pedjvak]

as attach you can find my sample file

[orange]

There was a project discussed recently that dealt with similar concepts.
It had some basic item (lenses) and all sorts of attributes and standards.
There are various posts in UtterAccess- by HawkEye -
here are some . I think you may get some ideas from this,
There is a database at http://www.utteraccess.com/forum/Tab...-t1998199.html

Other related links
http://www.utteraccess.com/forum/Opt...-t1998525.html
http://www.utteraccess.com/forum/Aut...-t1998395.html
http://www.utteraccess.com/forum/Mak...-t1998333.html