table linked

[steve111]

hi,
I have a table tat has engineering information in it.
I also want to create another table with sales information in it
there is a "part number" in the engineering table that will be put into the sales table
when the engineering table gets new part put in it can the sales table get that information in it automatically with looks up or links

thanks
steve

 

[CJ_London]

can the sales table get that information in it automatically

what do you mean by automatically?

 

[steve111]

hi,

when I put a part number in the engineering table can it also go into the sales table at the same time without me having to input it into that table

thanks
steve

 

[CJ_London]

What you are describing does not sound like tables, perhaps you mean populating a combobox in the sales table? Perhaps you can provide some example data of the engineering and sales tables plus what you want to happen when you add a record to the engineering table.

 

[smig]

why do you need exactly the same data entered in two tables ?
This make no sense

 

[steve111]

hi

there is a form called products and this is completed by engineering.
this has 2 fields

1. product number ie gc12345 product description ie capactor to drawing 12345

a new product could be generated by engineering and put into the form

sales

they need the part number in there quote, invoice etc but they don't want that description ( customer requirement sometimes)

I dont want sales to be able to enter data or edit data in the form/table created by engineering

therefore I thought create a table for sales. with all the same product numbers in and thy put there own description in ( sales only)

but how will they know to enter the new product number in the sales form/table when engineering have entered a new one in theirs

that's why I wanted to enter the data one time and it went I both tables

steve

 

[CJ_London]

You would be better having one table with 3 columns,

ProductCode
EngineeringDescription
SalesDescription

Then don't allow engineering to see the SalesDescription on their form and visa versa for EngineeringDescription.

 

[steve111]

ok , thanks
I will set it up that way

steve