I am confused please help me

[pedjvak]

What I have :
Data base with 2 tables named " fit up & material"
the materials which income to my site would be registered by warehouse's user in database(material table)


with some parameter that "Heat No" is primary and not duplicated
when work wanted be start in site we get some of material which joint with each other (welded)
therefor in database we get 2 material from one table(material) and register operation on it in another table( fit up )
problem is here that I can't issue this procedure in access by form or query

please help me base on my attachment

[June7]

Don't understand what you want to do. These two tables have no relationship. What do you mean by 'issue this procedure'?

[orange]

Suggest you look at this tutorial and try it with your own data
http://www.rogersaccesslibrary.com/T...lationship.zip

[pedjvak]

Can it help u what I mean ?
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 have a 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.

[orange]

pedjvak,

I am not sure what your fundamental issue is? It would appear that English is not your native language.
In your posts you have said you have 2 tables named " fit up & material" , then you say they are "material" & "Welding".
So you are confusing us too.
My post#3 gives an example of how to build tables for a business. You can use your own data with that process to get some start on your tables.

I don't think we can help you until we understand the issue/problem/opportunity. Can you tell us step by step WHAT you need help with?
As June7 pointed out, your tables do not appear to be related.
Having reviewed your database, and still not understanding what you have nor what you want, I am guessing that you should look at this recent thread that dealt with Fabrication.
https://www.accessforums.net/databas...ign-32250.html

Good luck.

[pedjvak]

Dear Orange

you are right I am not native
if you can plz visit this https://www.accessforums.net/program...-me-34153.html
I explain it clearly with sample file
thanks in advanced