Relathionship

[Robotower]

Hi all.
I have a question about relathionship, i whant to make my database like that when i insert data in one tables it write it too in another tables.



Like this, i have tree tables and all have a chip as primary key, and i whant when enter from form or tables the data in probe_stock data, that in the chip field in other two tables get that data.

[orange]

Three tables in the same database will not have the same PK.

I suggest you watch some videos on database design.
Here are some that may be helpful to you.
https://www.youtube.com/watch?v=4Z9KEBexzcM Database concepts
https://www.youtube.com/watch?v=kyGVhx5LwXw The relational Model
https://www.youtube.com/watch?v=IfaqkiHpIjo Data modeling

good luck.

[Robotower]

Thanks, i fix the primary key problems. And i will watch wideo when i get soome free time. But for now i am in hurry because i youst start working, and need some quick help.
Now i need to make selection box for forms.
For chips field. Which look like xxx-xxx-xxx-xxx where x are some numbers. And if somone put 001-001-001-xxx where xxx is empty it show all chips wich start with "001-001-001".
How can i dou something like that? And after find those record, then it need to show like in regulary form the rest of choosen field for each record.